Hello,

I am having trouble putting together some code that allows the user to select an excel file from their hard drive and then automatically import a set range of data into a new Access table.

Whenever I run the code, I get the following Run Time Error: 3051 ' Jet can't open the database because it is opened exclusively by another user or you need permission to read its data'.

Here is the code I am using:


Please Login or Register  to view this content.
If anyone can either help me tweak the code to make it work or propose another set of code to accomplish the same task, I would be very grateful. I appreciate everyone's time and effort. Thank you in advance.