WinSQL » Knowledge base

Document information

Details

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?

Your Name

Email

Hide my email address

Captcha

Your Tip

Submit Tip