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: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.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com