[thelist] simple method for uploading CSV files to MSSQL

[Jeff Howden]

joel,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Joel D Canfield
> 
> I'm building an analysis app and need to provide a
> really simple way for a small group of users to upload
> CSV files to MSSQL. 
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

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.

.jeff

------------------------------------------------------
Jeff Howden - Web Application Specialist
Resume - http://jeffhowden.com/about/resume/
Code Library - http://evolt.jeffhowden.com/jeff/code/