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 !