[thelist] simple method for uploading CSV files to MSSQL

bruce bedouglas at earthlink.net
Mon Aug 4 12:58:56 CDT 2003


i know it's obvious, but you might post to the mysql list.... also, i'm
pretty sure there is an upload/populate command or comma delimited
files..... don't have it right here with me right now...


-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org]On Behalf Of Joel D Canfield
Sent: Monday, August 04, 2003 10:05 AM
To: thelist at lists.evolt.org
Subject: [thelist] simple method for uploading CSV files to MSSQL

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.)



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

* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt ! 

More information about the thelist mailing list