Blueprint for SQL data to excel in real time.

[greggue]

I want to extract some data from a SQL database and then export it to an excel spreadsheet, that will be posted on a webpage in real time.



I have created a series of queries for a report in access. I then export the data to an excel spreadsheet.
The spreadsheet will eventually be on a web page.
Using a combination of VB and Access, can someone guide me to the simplest way to basically have thos e 3 steps automated.
The front end is access.

[SteveF]

The critical step is the Excel export. Is your existing report based on just one query, with the others being preparatory in nature?

Have a look at the following in Online Help for Visual Basic within Access. You'll need to have a VB module open to get to it:

DoCmd.OpenQuery method
DoCmd.TransferSpreadsheet method