Upload big text file via adp client and ado to sql server

[Tore]

I need to upload a .txt semicolon separated file (table) to sql server 2000.
Currently this is done via DTS and it works very well, but it would be more
convenient to do upload from the client if acceptable speed can be obtained.

The configuration is based on SQL Server 2000 and Access 2000

The.txt file resides in a folder on the client computer. It contains about
150 000 records and 30 semicolon separated columns (fields).

How can I use ADO stream object (or any other object) to upload the file
from .adp-client to the destination tabe on sql server? What would the vba
code look like on the adp client to set up ado?

DoCmd.Transfertext is no solution for me. Too many bugs, at least in Access
2000, and probably too slow.

Regards

Tore

 

[RJ]

Stick with DTS, you won't get anywhere near the speed with anything else.
DTS is great at bulk data opeartions.

You call/execute a DTS Package from VBA code but it make take awhile to get
it working. I did this for a data conversion using ADP for a client last
year. Like everything else... "It's a Process"