|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Uploading & processing large amounts of data |
|
From: |
Dan Sumption |
|
Date: |
3/20/2001 10:08:22 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
