Microsoft Text ODBC Driver
This ODBC Driver is provided by Microsoft.
Coding
Include "Driver={Microsoft Text Driver (*.txt; *.csv)}" in the connection string to use this driver.
Description
Schema.ini
The schema information file tells the driver about the format of the text files. The file is always located in the same folder as the text files and must be named schema.ini.
[customers.txt]
Format=TabDelimited
ColNameHeader=True
MaxScanRows=0
CharacterSet=ANSI
[orders.txt]
Format=Delimited(;)
ColNameHeader=True
MaxScanRows=0
CharacterSet=ANSI
[invoices.txt]
Format=FixedLength
ColNameHeader=False
Col1=FieldName1 Integer Width 15
Col2=FieldName2 Date Width 15
Col3=FieldName3 Char Width 40
Col4=FieldName4 Float Width 20
CharacterSet=ANSI
Check out this article for more information on the schema.ini file
http://msdn.microsoft.com/en-us/library/ms709353.aspx
Download link missing
The Microsoft Text ODBC Driver installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
Additional info or comments on this driver? Want to submit content?