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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
