Kyle,
Another thing to look into is the use of CFCONTENT. Not sure if that is
what you are looking for, but it has worked for me in the past. CF writes
the recordset out using the MIME type you specify.
<CFCONTENT type="application/ms-excel">
HTH,
Dan
----- Original Message -----
From: "Seth Bienek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 18, 2001 5:27 PM
Subject: RE: stupid excel as a datasource
>
> 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
-------------------------------------------------------------------------
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
