It you need to deal with Excel files, I have used this successfully for a while.
http://www.cftagstore.com/tags/cfxexcel2query.cfm You can find information on usage here. http://emerle.net/programming/help/installing_cfx.cfm Gabe Roffman eTesters > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On 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
