|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Uploading & processing large amounts of data |
|
From: |
Dan Sumption |
|
Date: |
3/20/2001 6:56:50 AM |
|
IP: |
62.172.111.199 |
Hope someone is able to help me - I need to write an ASP application which accepts large amounts of data, uploaded in the form of a CSV file, and performs some basic processing on it. For example, the application may check ID fields for each row uploaded, add the record to the database if it doesn't exist or update it to match the CSV if it does.
I have done something similar a long time ago, and used a kludge of half-Perl (to convert the CSV into an SQL statement) and half-ASP (VBScript). This was extremely inefficient and timed out a lot of the time.
Can anyone recommend a good method of going about this and/or any existing components or examples that may help me?
Much appreciated,
Dan. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
