Insert Into query from external database with a password

[AvatarZA]

I am trying to do an insert into statement like so "SELECT * INTO tblX FROM tblX IN 'C:\Temp\X.mdb" but database X has a password so I was wondering if anyone knows how to specify a password as I think access only wants a path.

 

[ByteMyzer]

If you are running a Make-Table Query to import data from database C:\Temp\X.mdb, protected by password MyPassword, here is the required SQL:

SELECT * INTO tblX
FROM [;DATABASE=C:\Temp\X.mdb;PWD=MyPassword;].tblX;

 

[AvatarZA]

Thanks, helped me out 1 time!