import entire access database into excel

  • Thread starter Thread starter Excel_Learner
  • Start date Start date
E

Excel_Learner

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

Thanks.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel Workbook from Sharepoint 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Excel 2010 table into Access 2010 - not listed as range 1
Access Import & Link section grayed out MS Access 2010 1
Automatically Importing Excel data into Access 6
Automatically Importing Excel data into Access without link 1
Import from notepad Pipe delimited text document 1
Importing fields from separate excel sheets to fill in info in dba 3

Back
Top