Access to Sql table bulk copy
Posted on 2004-08-23
In VB I have the user select the Access database, and SQL database dynamically. In other parts in VB, I have created a table in both Access and SQL using the command object. Now, I need to get the data from SQL table to Access table. Notice these are the tables I have created in VB so they have the same sturcture. I need the most efficient code example to bulkcopy the table from SQL to Access. NOT ROW BY ROW. Please help me with this. I am using VB6 and SQL 2000.