Hello-
I'm trying this thread again, because I haven't had much luck with it...
I'm trying to pull data from a database on our server and import it into a local table in Access. The only way I've found to do it is to create a recordset with the data and run an INSERT SQL statement cycling through all the records. I need to import about 50,000 records from 2 different db's. Needless to say, this method takes a bit long (it has to run 50,000 INSERT statements). Is there a more efficient way to do this?
A couple things:
-Using Access 2000
-I can't use a Pass through query
-I can't use linked tables
Thanks for any help!
I'm trying this thread again, because I haven't had much luck with it...
I'm trying to pull data from a database on our server and import it into a local table in Access. The only way I've found to do it is to create a recordset with the data and run an INSERT SQL statement cycling through all the records. I need to import about 50,000 records from 2 different db's. Needless to say, this method takes a bit long (it has to run 50,000 INSERT statements). Is there a more efficient way to do this?
A couple things:
-Using Access 2000
-I can't use a Pass through query
-I can't use linked tables
Thanks for any help!