BULK INSERT is your friend. Upload the CSV to the server, then call BULK INSERT like so:
BULK INSERT db..table from 'd:\my\data_file.csv' It has quite a few options for file types, field and row terminators, how many rows, format files, etc. Check out SQL Server Books Online for more details. Ben -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Mineer Sent: Friday, February 24, 2006 12:06 PM To: cfcdev@cfczone.org Subject: [CFCDev] Web Based import I want to create an application in Cold Fusion that would allow someone to select a csv or excel file from their computer and import into MSSQL which resides on my server. They would need options to map fields, make changes (i.e. strConv(field1,3) or left(field1,5) ) and even save a profile once they had it right. Currently, the user has to send me the file, I import into an access table, create an append query and then use DTS to get it into SQL. I would really like to shift this work to the user. Can someone point me in the right direction to some material that can get me going on this. Any pointers or experience from having done something like that yourself. Any comments would be appreciated. Thank you, -- David Mineer Jr --------------------- The critical ingredient is getting off your butt and doing something. It's as simple as that. A lot of people have ideas, but there are few who decide to do something about them now. Not tomorrow. Not next week. But today. The true entrepreneur is a doer. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org
