Copy a Table from 1 Database to Another

[Tiago Filipe]

Hi,

I'm using VB 6 Sp5 and ADO to work with a Access mdb, and i need to copy
the full tables from 1 Database to another. I tryied to construct the SQL
query in Access, but the destination table is Password protect, and the sql
string provided from MS access isn't valid in ADO.
If i try to make the SQL Query in Access it looks like this:

INSERT INTO [;PWD=PSW].Table1 IN 'C:\PathTo\My.mdb'[;PWD=PSW]
SELECT Table1.*
FROM Table1;

And doesnt work, i get error (ADO)
Nº -2147217900
Descr.: Syntax error in INSERT INTO statement.

Thanks Again