|
-
July 18th, 2001, 09:42 PM
#1
FTP File - Parse - Load SQL Server?
What's the most efficient (ie, fastest processing) way to take a comma-delimited text file from an FTP site out on the Net, parse it into its individual fields and load it into a SQL Server table on the local website?
I need to set this up for an end-user who doesn't know how to transfer files, and doesn't know how to work in SQL Server itself.
We have a website, made up of ASP pages powered by Java Script and VB Script. We were thinking of letting the scripting languages do the work, but 4500 records were taking over 5 minutes! (Way too slow).
So, our next thought is a VB DLL, using ADO to load the tables, and being called from the ASP pages. But, never having written a DLL to be accessed by VB Script, I'm not sure how fast this will be.
Can someone suggest a fast, automated way to do this?
TIA.
Dave
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|