I have recently performed this task.
<cftip>
This is what you need to do to connect to an excel spreadsheet with an ODBC
datasource.
1)If you want you can add labels to the top of each column which the ODBC
driver will treat as a colum name, otherwise it uses something like field1,
field2 .. fieldn.
2)Highlight all the data on the sheet.
3)Click on insert/name/define.. on the main menu.
4)Fill out the options.
5)You can now perform SQL on the excel speadsheet.
datasource = datasource
table = defined name of selection
column = column
</cftip>
On Thu, 18 Jan 2001 17:22:55 -0700, [EMAIL PROTECTED] wrote:
hey all,
we need to write out some excel files based on different query
results & for some reason (i think its cf 4.5) the custom tag we
WERE using no longer works.
all of the new tags I can find seem to require excel on the server
which to me sounds like a bad idea.
SO, for the time being, I'm trying to write directly to an xls file
as a datasource. seems possible, I mean, cfadministrator will see &
verify the thing right?
yeah right.
no matter what I do, I cant' get any tables to show up (which I assumed
would be the "sheet" names)
here's what I THOUGHT:
sql = excel
datasource = datasource
table = sheet
column = column
any help here would be appreciated.
thanks,
kyle dubben
--
Kyle Dubben
Gothica Creative, Inc.
1801 Laws Street
Dallas, TX 75202
214.720.0884 ph
214.303.0698 fax
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
Sincerely,
Ricardo Sanoja
_______________________________________________________
Send a cool gift with your E-Card
http://www.bluemountain.com/giftcenter/
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
