I want to install a MS Access database on MS SQL Server in VB6.
Until now I managed to install database structure using T-SQL script.
Now I need to populate the DB on server with data from the original .mdb file; I need a colection of all (user)tables existing in the DB, and then use some kind of
INSERT INTO table1
  SELECT * FROM table2;
table1 being on server DB
table2 being on local DB
can u help me??