Discussion Locked

AccessTables to Excel Worksheets

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I convert several Access97 Tables into different worksheet in a single Excel Spreadsheet.

3 replies

by dklippert

Assuming Excel 97, choose File>Save As/Export. Change the File Type to Excel, create a new Workbook name or select an existing Workbook, click OK. Do this for each table. If you select the same Workbook, the tables will be exported as separate sheets.
If you want an easier way, just drag the table out of Access into Excel

This discussion is closed to new replies.