Hey Kyle,
If I understand your question correctly, you are trying to write out a file
that Excel can read?
It's a cakewalk to generate a properly formatted .CSV file from database
output with CF.. And Excel reads those easily, with no COM objects...
Seth
------------------------------
Seth Bienek
Solutions Development Manager
Stonebridge Technologies, Inc.
972.455.7294 tel
972.404.9754 fax
ICQ #7673959
------------------------------
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Gothica Creative
> Sent: Thursday, January 18, 2001 6:23 PM
> To: [EMAIL PROTECTED]
> Subject: stupid excel as a datasource
>
>
> 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
>
-------------------------------------------------------------------------
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
