Hi. I'm trying to update one of my company's software products written in MS Access 2000 that sends information, via the internet, to SQL Server 2000. Originally the code inside the Access database used the old DAO format and I updated it to ADO.

Although the ADO is faster, it is only slightly faster than the original code, and because of the mass amounts of data being transferred it is still too slow for end user satisfaction. I was wondering if there was a way, or method, to do like a BULK INSERT table per table. I'm thinking one of the main reasons the current process is slow is the high number of Inserts to each table.

Any suggestions would be greatly appreciated.

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

In message <u548Ex#eEHA.3476 (AT) tk2msftngp13 (DOT) phx.gbl>, SqlJunkies User
<User@-NOSPAM-SqlJunkies.com> writes

Probably the best option would be to use the Access upgrade wizard tool.
You could use DTS/SQL the Import Export Wizard that woudl build a
package and transfer all tables and data from Access to SQL server, but
this will not respect your other code and constraints, as it really just
moves the data.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org