[thelist] simple method for uploading CSV files to MSSQL
Joel D Canfield
joel at spinhead.com
Mon Aug 4 13:38:21 CDT 2003
Not *my* SQL, but *MS* sql, as in Microsoft . . . and I really need
something which doesn't require use of the database tools; these folks
don't have the time or inclination to bother with it.
Thanks
spinhead
-----Original Message-----
From: bruce
Sent: Mon 8/4/2003 10:58 AM
To: thelist at lists.evolt.org
Cc:
Subject: RE: [thelist] simple method for uploading CSV files to
MSSQL
hey..
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...
bruce
bedouglas$earthlink.net
-----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.)
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
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
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