How do i extract tables from MS Access into 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.


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.

[pbaldy]

Create a query that returns the data in the desired format and export that.