File Format & Compatibility

Export Microsoft Access Queries with Multi-Valued Fields to CSV

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

The user needs to export Access query results that reference a multi-valued field to CSV.

Export Microsoft Access Queries with Multi-Valued Fields 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.
Before you start

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.

Solution 1Recommended

Export the filtered results through a temporary table

Use a make-table query as a temporary workaround when a direct query export fails.

1
Open the query in Design View

In the Navigation Pane, right-click the query and select Design View. Check that the IN criteria return the records you need.

2
Select exportable values

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.

3
Create a temporary table

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.

4
Export 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.

5
Check the CSV

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.

Export the filtered results through a temporary table
Check the row layout: Selecting the Value subfield can produce multiple rows for one entity. If the make-table query still includes a multi-valued field, its export may also fail.
Free Microsoft Office alternative

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.

Open and review CSV data exported from AccessCompatible with Microsoft Excel formats including XLSX and XLSFamiliar spreadsheet interface for sorting and filtering exported rowsFree, lightweight office suite for everyday document work
microsoft office alternative - wps office

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.