Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Exporting to Access

Author  Topic  rdugre Starting Member 32 Posts Posted - 2001-05-28 : 11:10:16 I have an ASP application that needs to export data from a SQL database to a Microsoft Access database to be downloaded by my users. I already accomplished this via an ActiveX DLL that I built, but it is extremely slow. The bottleneck seems to be performing all of the INSERTs into the Access tables. Is there any way to "stream" the data into the Access tables from the SQL Server tables? Basically, I am currently doing a series of SELECTs from SQL and INSERTs into Access via multiple loops. Any ideas or references would be greatly appreciated. ---------------------------------------------- The higher the monkey climbs, the more he shows his ass.