RE: reading an XLS file into a query...
If you're using CF5, you can specify a connection string, so no DSN is required. That way you can access it through ODBC. Why no DSN? If you can't go that route, I have a hard time believing that your other options (COM, DTS) are available if you can't set up a simple DSN. --- Billy Cravens Web Development, EDS [EMAIL PROTECTED] -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 6:08 PM To: CF-Talk Subject: reading an XLS file into a query... Hello All, Here's what I want to do: User uploads an XLS file (column names will always be consistent) - this I've got figured out. CF reads the XLS file into a query and dumps the data into a SQL table. - part of this I can't figure out. I know how to read from a text file and do an import into SQL that way, however, my problem is that I need to read DIRECTLY from an XLS file that has been uploaded. NO DSN connections are allowed. I'm thinking maybe a COM object? What do you all think? Where should I start hunting for knowledge? I've tried CFFILE, CFHTTP, and CFCONTENT. None of those do the trick. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: reading an XLS file into a query...
my suggestion (since i've done this exact thng) is to write a stored procedure that calls a DTS package to import the data into an SQL table. then call a second stored proc to massage it into a format that you can use. christopher olive, cio cresco technologies, inc http://www.crescotech.com -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:08 PM To: CF-Talk Subject: reading an XLS file into a query... Hello All, Here's what I want to do: User uploads an XLS file (column names will always be consistent) - this I've got figured out. CF reads the XLS file into a query and dumps the data into a SQL table. - part of this I can't figure out. I know how to read from a text file and do an import into SQL that way, however, my problem is that I need to read DIRECTLY from an XLS file that has been uploaded. NO DSN connections are allowed. I'm thinking maybe a COM object? What do you all think? Where should I start hunting for knowledge? I've tried CFFILE, CFHTTP, and CFCONTENT. None of those do the trick. ---mark === Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti=== ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
reading an XLS file into a query...
Hello All, Here's what I want to do: User uploads an XLS file (column names will always be consistent) - this I've got figured out. CF reads the XLS file into a query and dumps the data into a SQL table. - part of this I can't figure out. I know how to read from a text file and do an import into SQL that way, however, my problem is that I need to read DIRECTLY from an XLS file that has been uploaded. NO DSN connections are allowed. I'm thinking maybe a COM object? What do you all think? Where should I start hunting for knowledge? I've tried CFFILE, CFHTTP, and CFCONTENT. None of those do the trick. ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 AIM: markwarric Yahoo: Serengeti = ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
