Question: how to export large data from access to text file?
Answer: Click on the table or query to export from (in this example “Top Ten Orders by Sales Amount” on the left)
Click the “External Data” tab at the top of the window.
In the “Export” section click “Text File” and a wizard will appear.