General discussion

Locked

AccessTables to Excel Worksheets

By frankus ·
How do I convert several Access97 Tables into different worksheet in a single Excel Spreadsheet.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

AccessTables to Excel Worksheets

by DKlippert In reply to AccessTables to Excel Wor ...

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

Collapse -

AccessTables to Excel Worksheets

by frankus In reply to AccessTables to Excel Wor ...

Thanks again for the help, Doug! Needless to say: I tried it and it works!

Collapse -

AccessTables to Excel Worksheets

by frankus In reply to AccessTables to Excel Wor ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums