up vote 1 down vote favorite
share [g+] share [fb]

I have an Access file that has 4 tables. How can I convert one of the tables to an excel spreadsheet?

link|improve this question
100% accept rate
feedback

1 Answer

up vote 1 down vote accepted

There is the ability to export tables in Access to Excel. Using Access 2007, after opening the table go to the External Data tab and in the Export block click on the Excel button (it has the icon of a table in Datasheet view with an Excel icon in front of it).

Export Access to Excel

link|improve this answer
If the access db has forms, how can I navigate to the table? – Omar Nov 3 '10 at 0:39
sorry i have taken so long to respond. on the left hand side of the screen in Access is there a panel that fills the window from just beneath the ribbon to the bottom on down? if yes, does it say "Forms" at the top left with a little down arrow next to double arrows pointing left at the top right? if yes again, if you click the down arrow can you select "Tables and Related Views" under "Navigate to Category"? if you answered yes again then you should now be seeing all the tables in the database. – Xantec Nov 5 '10 at 12:39
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.