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