Access to Excel Question

I have recorded and modified a macro to link an access database to excel. I have very little experience with VB and am having a few problems.

1: When I use the string filenm that is pulled from the worksheet for the file path I get the following error:
Data file: ‘C:\file.mdb’ not found. Would you like to connect to C:\file.mdb instead?
When the file name is hard coded I do not get this error, any way to get rid of this error?

2: How can I import only specific columns from the database table?

3: The data files I need to work with do not have an .mdb extension (they are db1, lf1, etc). The files are opened with access and when I replace the .db1 or other extensions with .mdb excel correctly imports all data. However, when left in the original .db1 form I get a window to “Enter MS JET OLE DB Initialization Information” and I can’t get the data to import. Can anyone help with accessing a database with out an .mdb extension?

Here is the code I'm using:

Please Login or Register  to view this content.

Thanks for any help.

Hello glickz,

Welocme to the Forum!

To make your posts easier to read, copy, and edit please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
1. Select all your code using the mouse.
2. Click on the # icon on the toolbar in the Message window. This will automatically wrap the text you selected with the proper Code tags to create a Code Window in your post.

OR you can also do this Manually by placing the tags
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end of the last line.