WinSQL » Knowledge base

Document information

Document ID:754
Subject:Insert data into text files from MS Access
Creation date:7/29/09 11:39 AM
Last modified on:12/12/18 10:38 AM


The ODBC driver for MS Access allows you to directly export data from any table in to a plain text file. Assume you have a table called Customer. The following query will export data into a file called c:\data\Customers.txt

select *
INTO [Text;FMT=Delimited;HDR=Yes;DATABASE=C:\data\;].Customers.txt
from Customer

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Important: This area is reserved for useful tips. Therefore, do not post any questions here. Instead, use our public forums to post questions.


Social Media

Powered by