CODEWITHSUNDEEP
ms-accessexport-to-excelexport-to-csv
DavideChicco.it
DavideChicco.it

Reputation: 3470

Exporting data from Microsoft Access table file subsets to plain text

I have a problem in exporting data from Microsoft Access. I have an Access file made of several rows and columns, like this:

Data table main data

Every row contains a subset of data, that could be observed by clicking on the "+" button:

Data table subsets

I would like to export all these data (main table & subsets), but there's a problem. When I click on External Data -> Export -> Text file, Ms Access exports only the main table data (1st Figure), and completely omits the data of the subsets (2nd Figure).

How could I export all these data (main table & subsets)?

Thanks

Upvotes: 0

Views: 752

Answers (1)

Beth
Beth

Reputation: 9607

Create a query denormalizing the data you want the way you want, then export that to Excel.

Upvotes: 1

Related Questions