Unanswered: Copy Table from one database to another
Hi guys Help please! Say I have db1.mdb and db2.mdb and in db1.mdb I have a table named 'members' and i want to copy the table and the values to db2.mdb how will i do this programmatically. Thanks in advance!
I found this solution which seems to solve my problem. http://www.experts-exchange.com/Micr...html#a22781336
So, I modified my sql statement so that instead of
SELECT * INTO newTable IN E:\Databases\myDb.mdb FROM sourceTable;
now I am using
SELECT * INTO newTable IN ' ' [;Database=E:\Databases\myDb.mdb;pwd=myPassword] FROM sourceTable;
After IN there are two single quotes indicating a ZLS, what does that mean?
I would be happy if you could help me with an explanation or guide me to a site where I could learn more about this syntax.