I need to programmatically copy all tables from one database to another one (thereby converting file types from SQL to Access in the process). I read about SELECT INTO and INSERT INTO, but to do this I need to know the names of the source tables.
Is there a way of doing this
a) without knowing the table names
or
b) figuring out the names of all the tables in a database?
Is there a way of doing this
a) without knowing the table names
or
b) figuring out the names of all the tables in a database?