Microsoft Text ODBC Driver
This is a ODBC Driver 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
Connection Strings
Additional info or comments on this driver? Want to submit content?
Send an e-mail to
Send an e-mail to
Selected Articles