Exporting to Excel

[Jennifer Sanders]

I need to export Access data to an excel spreasheet that
will stay current automatically. We want to offer an
excel sheet of product and prices for an ecommerce site as
a download for wholesale customers. The excel sheet would
always be downloadable from the same link, and we would
want the link to contain an excel sheet with data from
Access. When the Access DB gets updated, we would like
the excel sheet to reflect the changes. The excel sheet
can be updated on an interval, but it would have to be
automated. Any clues?

 

[fred]

What's the problem? create a query, put that query in a macro to
export/output that query to the file that is linked to. Have a
scheduling program open Access calling that macro. Works well for me.

Unless I am missing something?