import entire access database into excel

[Excel_Learner]

Can someone tell me how to import all tables in an Access database into Excel
with crosponding Excel tabs automatically generated?

Thanks.

 

[Klatuu]

If you want to do it from Excel, you should ask the question in an Excel
newsgroup.
If you want to do it from Access to Excel, use the TransferSpreadsheet.
You will need to do one export for each table. You can use the Range
argument of the TransferSpreadsheet to specifiy a specific worksheet.

 

[Douglas J. Steele]

For an example of using Automation from Access to Excel, see my July, 2005
"Access Answers" column in Pinnacle Publication's "Smart Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html