Automatic export of query

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a linked table to an odbc source. Then a query pulls all the
tables and fields into the one query. I need to export that query to a
excel spreadsheet. Is is possible to have the query exported
automatically when ever the table is updated? For some reason the
table I am connecting to is too large and it crashes my program.

Thanks
Bob
 
Not AFAIK since Access doesn't support triggers.

OTOH, you don't want to automatically start the export considering that you
are having problems with the Table at the moment.
 
You could create a form that sits in the background and has a timer
event associated with it, so it would check the database every so
often to determin whether the table has been updated. If it has, you
could use DoCmd.OutputTo to export the results of your query to Excel.

Regarding the problem you are having. How many records does the query
generate. I think Excel has a limit of the number of records you can
export to it. Also, what version of Office are you using, that may
make a difference?

--
HTH

Dale Fye


I have a linked table to an odbc source. Then a query pulls all the
tables and fields into the one query. I need to export that query to a
excel spreadsheet. Is is possible to have the query exported
automatically when ever the table is updated? For some reason the
table I am connecting to is too large and it crashes my program.

Thanks
Bob
 
I will have to try your method. Though I have never done it before.
Still learning Access. There are not alot of tables in the db I am
connected too. For some reason it crashes my companies program when
the connection refreshes. It is fine as long as the user is working
with it. But when they stop and come back that is when it crashes.
 
Back
Top