RE: Here's a question to chew on

Hi Brian,

I had to do something similar - I used ASP and the Microsoft
FSO (File System Objects) to create a comma-delimited text file.
 After creating the text file, the ASP called SA-FileUp (of course,
you can use something different) to download the file to the
user's desktop.

If you have Excel installed on your servers, you could probably
use Excel's object model to create an Excel file and download
that, so folks wouldn't need to muck with the comma-delimited
file.

And of course, you can probably do this all in CF (esp. since
CF can invoke COM objects).

HTH ...
 

>--- Original Message ---
>From: "Kortland, Brian" <Brian.Kortland(at)AIG.com>
>To: "'hwg-techniques(at)hwg.org'" <hwg-techniques(at)hwg.org>
>Date: 11/17/00 3:21:32 PM
>

>Hi All,
>
>I have not seen this, and don't know if there is a utility or
applet or
>something out there, but does anyone know of a way to dump query
results
>into an excel file that can be downloaded.
>
>We have a bunch of intranet sites and we are using Cold Fusion
to diplay
>query results. People are now asking us to come up with a way
to allow users
>to take those same results and have them dump to an excel file
or to a txt
>file.
>
>Anyone have an idea how to do this. It can be Cold Fusion, ASP
or whatever.
>We just are curious if this is being done somehow. 
>
>Thanks,
>
>Brian
>
>
----------------
Sent from a WebBox - http://www.webbox.com
FREE Web based Email, Files, Bookmarks, Calendar, People and
Great Ways to Share them with Others!

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA