How to Preserve Quotation Marks When Exporting Access Query Results
Question details
Users need to prevent quotation marks from being altered, duplicated, or converted into typographic quotes when moving query results from Microsoft Access into a text file.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Exporting or copying query results containing single or double quotation marks into a document or text editor.
- Observed behavior
- Formatted text editors like Word or WordPad automatically change straight quotes to typographic smart quotes, or misinterpret repeated quotation characters when pasting clipboard data from Access.
Ensure your query results in Microsoft Access are correctly formatted and save your current database work before initiating a file export to prevent data loss.
Export the Access Query Directly to a Text File
Bypassing the clipboard by exporting directly from Access to a text file prevents other programs from automatically altering your quotation marks.
Open your database in Microsoft Access and select the query you want to export from the Navigation Pane.
Navigate to the 'External Data' tab on the top ribbon and click on 'Text File' within the Export group.
Enter the destination file name and ensure the format is set to a standard text file extension like .txt.
Follow the Export Text Wizard steps, choosing 'Delimited' or 'Fixed Width' as required for your data structure, and finish the export.
Copy Query Results to a Plain-Text Editor
If you must manually copy and paste the query data, use a plain-text editor like Notepad to avoid automatic smart quote replacements.
Use WPS Office for Reliable Document Formatting
While Microsoft Access handles databases, processing text and data seamlessly is easier with a lightweight, highly compatible office suite. WPS Office offers extensive control over text formatting, allowing you to turn off smart quotes easily and ensure your data documents perform perfectly without unexpected character changes.
Frequently Asked Questions
Why do my straight quotes change when pasted into Microsoft Word?
Microsoft Word has an AutoFormat feature called 'Smart Quotes' that automatically replaces standard straight quotation marks with curved or typographic quotes for better visual presentation. This can corrupt raw data strings meant for coding or exact database imports.
Can I turn off smart quotes in standard word processors?
Yes. In most advanced word processors, including Word and WPS Writer, you can disable smart quotes by going to Options > Proofing > AutoCorrect Options, and unchecking the specific option to replace straight quotes with smart quotes as you type.
Why am I seeing extra repeated quotation marks when pasting?
When copying from an Access datasheet, the clipboard may enclose text fields containing quotes or commas with additional double quotes as part of standard CSV/TSV clipboard escaping rules. Exporting directly to a file avoids these clipboard escaping issues entirely.
