DBASE to SQL update via ASP

[Esoteric]

I am updating a remote DBaseIV file into an SQL database. This part works fine however its really slow doing it the way that I am.

Is there a way to mass update a table with ASP? For instance I am currently adding a new record to the SQL database for every record in the DBaseIV database that is not already there.

Is there an SQL script that could update all?

Like: UPDATE Vendors.* FROM Vendors FOR EACH Record in 830 kinda thing?

 

[FengShui1998]

esoteric,

If you are updating an SQL database, why don't you try using the import tools in SQL server. This way you bypass the WEB server and it's limitations.


fengshui1998

 

[Esoteric]

Thats fine for me but we want this to be a semi automated process. The user uploads the file via the browser, I rename the file and start the import all works great buts its dog slow....

Averages 1 record per second, average records being imported about 10,000. So you can quickly see why this is a great solution for the novice end user but takes way to long.

Does anyone here know if its the DBaseIV ADODB connection that causes my SQL server to climb to 100% and work so slow and hard?

Or did I do something wrong?