Import Query as Table?

[Blackshark]

Just wondering - can I import a query from an external MDB as a table through VBA? Is it the same code as importing a table?

 

[sxschech]

What about a make table query to "import" the data.

SELECT * INTO tblLocal FROM tblExternal IN 'C:\Databases\External.MDB';

 

[phatlosz]

I've been looking for this for a day and half now! I'm so excited to be this close.

I got an error, the db I'm trying to connect to is password protected. I got the "Invalid Password" error.

How do I include the password in my query?

 

[Golom]

SELECT * INTO tblLocal 
FROM [;Database=C:\Databases\External.MDB;PWD=thepassword].tblExternal