Exporting to Excel....

[andrest]

I have 2 Access Database tables. I want to export them to separate sheets in the same excel file. Is this possible?

Thanks in advance.

Andre

 

[BrainB]

AFAIK Access overwrites tables of the same name. So exportg twice to different files and copy one of the sheets across. Regards
BrianB
** Let us know if you get something that works !
================================

 

[andrest]

Thanks BrainB,

Can this be automated?

Andre

 

[ETID]

You would not need to export the data to excel, (too many steps)...

Create a live link to the table or query from within excel,

From excel click Data>Get External Data>New Database Query>....the choose msaccess databases* from the list...follow the wizard from there (to select your mdb, table or query)
then return your data to excel.

You can opt to use the wizard or MsQuery (a gui type interface, similar to access)at this point...
after your comfy with this...I would recommend the MsQuery option.


when data is returned,...you can right click in the data and select properties to refresh on open...auto fill formulas etc.

this is now a live link, any time the workbook is opened. your current / up to date access data comes in (if you set the refresh on open option)