[thelist] ColdFusion/Access Table Export

[Bruce Heerssen]

If the database file is in the web root somewhere you can simply link directly to it. If the database is outside the web root, which
is normally recommended, then link to a cfm page that has two tags in it: cffile and cfcontent. The first gets the file, the second
sets the mime type of the page to keep the browser from trying to display the file.

Looking back at your message, I noticed that you said 'table'. You can download a COM object that can build an excel file on the fly
based upon a query. Try http://cfcomet.com for this.

Shout if you need more help

-Bruce

> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of jon steele
> Sent: Wednesday, May 02, 2001 5:38 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] ColdFusion/Access Table Export
>
>
> Hello,
>
> I'm using ColdFusion to display a Access database in HTML format on a
> page. This way the user can look at the info. BUT I want to add a
> feature so the table can be exported (as excel maybe?) onto the user's
> hardrive. So they could get the individual table as a file on their
> computer. It can be in Access format, but then the user would have to
> convert it themself, which would also be fine.
>
> Any clues on how to do this would be appreciated.
>
> Thanks,
> Jon.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !