I'm about to do the same thing with Excel only. I believe you can make a new datasource on the fly and point it to the Excel document.
I was going to make this datasource and then use coldfusion to pull from one datasource (Excel) into my other datasource (mySql). I'm not sure how you would od the cvs. most likely just a really robust parser. On 2/24/06, David Mineer <[EMAIL PROTECTED]> wrote: > 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 > > > -- Dustin Tinney [EMAIL PROTECTED] 616-776-6020 Software Journeyman Atomic Object LLC ---------------------------------------------------------- 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
