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


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?

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

Navigation

Social Media

Powered by 10MinutesWeb.com