Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

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

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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