Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wsbolt
Starting Member
1 Post |
 Posted - 2007-05-10 : 02:23:45
|
| Need help in creating a asp page or vbscript to upload into a sql db from csv file. The provided app my hosting server has is B.S. they have limited to a 2MB upload, and it always times out and I have a 25MB file to upload. The table I'm uploading into is 129 columns, and the csv is a tab delimited file. I've looked at a few things but nothing really works. Any examples or help in this type of thing would be great. If you can show me an app that actually works conneting into a sql database I can modify it to my needs.thanks in advance. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-10 : 02:27:17
|
check out bcp.exe in BOL.
www.elsasoft.org |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-05-11 : 09:54:48
|
| Would this "well timed" article be in order???http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83181 |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-05-11 : 12:11:03
|
if it's already in the form of a csv, there's no reason to use SqlBulkCopy. That woudl require extra work in fact, because you'd have to implement an IDataReader over the csv. I think you should look at bcp.exe or a BULK INSERT command.
www.elsasoft.org |
|
|
|
|
|
|
HELP!! bulk upload into sql using asp or vb