[thelist] simple method for uploading CSV files to MSSQL
Sean G.
ethanol at mathlab.sunysb.edu
Mon Aug 4 22:03:48 CDT 2003
Howdy,
We convert csv files to XML, do some format checking, and feed the XML as a
parameter to a stored procedure that updates the database. It's not too
complicated.
I'm stuck with c# and dot net, but you should be able to do the same thing on
the int(er|ra)net with any platform that can take the file and make a database
connection.
Let me know if you want more details.
HTH,
Sean G.
"I'd like to bury my face in two dozen 'Krispy Kreme' glazed donuts & just
lie there & think about Hello Kitty!"--Zippy
>-----Original Message-----
>
>> give em a file upload and then do a bulk insert.
>>
>> for example:
>>
>> BULK INSERT databasename.dbo.tablename
>> FROM 'filepath'
>> WITH (FIRSTROW = 2
>> , BATCHSIZE = 200)
>>
>> just look in your sql books for all the parameters and usage info.
>
>Thinking out loud here: If I create a web interface so they can fire off
>the SQL, their app could drop the data in a specified location, then
>they perform the BULK INSERT using my web interface, then use the web
>analysis tools to sort/filter/report.
>
>I think that'll work.
>
More information about the thelist
mailing list