Export all tables in Access to a SpreadSheet

[hewstone999]

I have created about 7 tables in Access, which all have the same column names. I want to export all of the table's data at the same time into a Excel SpreadSheet using VBA.

Also I want specify where i want the data to go in the SpreadSheet e.g. All data will be exported to cell A4.

Any ideas or help?

Kind Regards
Richard

 

[KenHigg]

a. Sounds like you may have a normalization issue. Should all of this data be in one table?
b. You may be able to use a union query to export these
c. or, You may be able to append all of them to a temp table and export it...