Board index » delphi » Bulk Copy Between SQL Server 7 and Access 97

Peter Crowther

Delphi Developer

Tue, 03 Aug 2004 17:58:36 GMT

Bulk Copy Between SQL Server 7 and Access 97

Is it possible to bulk copy tables from SQL Server 7 to Access 97 (and back
again) using the ADO type library?

Does anyone have a code fragment?

Thanks

Other Threads

1. SQL Server Bulk Copy

2. Access 97 ADO bulk insert

3. :SQL Bulk Copy Error

4. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

5. Bulk Export from SQL Server to MDB

6. copy table from SQL Server to Access DB (programmable)

7. Copying Access table to SQL server

8. Copy SQL Server Table to Access Table

9. Using OLE to do SQL-Server Bulk Transfers (BCP)

10. My COM server incompatible in Access 97