[thelist] simple method for uploading CSV files to MSSQL

Joel D Canfield joel at spinhead.com
Mon Aug 4 12:05:11 CDT 2003


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. 

If nothing simple can be done, they could be shown something less than
simple, but these guys are engineers, not database geeks ;) so I'd
prefer to make it mindlessly simple if possible.

The CSV files are extremely regular; no exceptions to deal with, just
dump two sets of identically formatted and positioned data into two
different tables. (What I mean is, there will be one table of data,
always formatted the same, and another table of metadata, always
formatted the same; but the two tables aren't the same as each other.)

tenks

spinhead

--
Joel D Canfield
joel at spinhead.com
916.771.9297 office
916.765.1712 cell
10001 Woodcreek Oaks Boulevard #233
Roseville CA 95747



More information about the thelist mailing list