|
|
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: | 7/29/09 11:39 AM |
|---|
Details
The ODBC driver for MS Access allow 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? Please add it below. Your name and tip will appear at the
end of the document text.
|
