Discussion Locked

Access DB to excel Sheets

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I export data from my access tables to excel ?

many thanks
Itay

3 replies

by jennifer.gardner

You didn't say what version you're using, but in Office XP (Access 2003), you can open any report then click on the "Office Links" icon on the toolbar and select "Analyze it with Microsoft Excel".

by dklippert

1) File>Export and change the Save as type to Excel.
2) Copy and Paste
or
3) In Excel, Data>Import External Data>Import Data

This discussion is closed to new replies.