Export Microsoft Access Queries with Multi-Valued Fields to CSV
Question details
The user needs to export Access query results that reference a multi-valued field to CSV.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A query filters records using an IN clause on a multi-valued field, and its results need to be exported.
- Observed behavior
- Access may fail to export the query results directly to CSV.
Open the query in Access and check which multi-valued field and IN criteria it uses. Decide whether the CSV should contain one row per selected value, since a CSV cell cannot retain Access's multi-valued field structure.
Export the filtered results through a temporary table
Use a make-table query as a temporary workaround when a direct query export fails.
In the Navigation Pane, right-click the query and select Design View. Check that the IN criteria return the records you need.
In the design grid, include the scalar fields needed in the CSV. If you need individual values from the multi-valued field, select its Value subfield rather than the whole multi-valued field, and check the resulting rows in Datasheet View.
Return to Design View and select Query Design > Make Table. Enter a new temporary table name, click OK, and select Run to create the table.
Select the temporary table in the Navigation Pane, then choose External Data > Text File in the Export group. Choose a destination ending in .csv, select Delimited and Comma in the export wizard, and finish the export.
Open the CSV in a spreadsheet or text editor and compare its rows with the query results. When you no longer need the temporary table, right-click it in the Navigation Pane and select Delete.

Replace the multi-valued field with related tables
Use a conventional many-to-many design for a longer-term solution that makes querying and exporting individual values easier.
Review your exported Access CSV in WPS Spreadsheets
WPS Office is a free, lightweight alternative for reviewing and editing exported data in a familiar spreadsheet interface. Open your CSV or Excel files in WPS Spreadsheets for an easy transition, though WPS does not fix Access queries or replace the Access database.

Frequently Asked Questions
Why can an Access query with a multi-valued field fail to export?
A multi-valued field contains more than one value for a record, while CSV is a flat text format. Queries that reference these fields, including those with IN criteria, can encounter export limitations. Try saving scalar results in a temporary table before exporting.
How do I export individual values from a multi-valued field?
In Query Design, select the field's Value subfield and the other columns you need. Review the results in Datasheet View before exporting; an entity with multiple selected values may appear on multiple rows.
Where is the CSV export option in Access?
Select the query or table in the Navigation Pane, then choose External Data > Text File in the Export group. In the wizard, choose Delimited and Comma and save the file with a .csv extension.
Will a make-table query always fix the export?
No. It is a workaround, and a temporary table that still contains a multi-valued field may also be difficult to export. Select scalar values and check the table's contents before exporting.
Can WPS Office run the Access query?
No. Run the query and export its results in Microsoft Access first. You can then open the CSV in WPS Spreadsheets to review, sort, or filter the exported data.




