How do i extract tables from MS Access into a single spreadsheet in excel?

[xwnoob]

hi,

Currently i know how to extract info from 1 table in MS Access into an excel spreadsheet. However, when i do that, Ms excel will create a new spreadsheet(page) for that table. This is a good way to differentiate tables but for me i need a different method.


How do i extract the info i want into a single spreadsheet? This is because my tables are interlinked and i want to show the info across a single spreadsheet.

 

[Lightwave]

Create a query with all the information in it that you wish to export and then export the query just as you would the table.

 

[tehNellie]

If you want multiple Tables/Queries in separate sheets in the same file, then once you've exported the first Table/Query, when you come to the subsequent ones, browse to the file you've just created on the first screen of the export wizard and the export should create a new worksheet with the table/query name within that file.

 

[DavidAtWork]

If you have multiple queries, you can export all queries to one workbook, it will automatically create a separate worksheet for each query assuming the queries all have different names.
If you want to export multiple queries which create records suitable to go into one table, then export to one worksheet, you should make your queries append queries so they dump all records into one table and then export
David