Microsoft Text ODBC Driver

This ODBC Driver is provided by Microsoft.

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

There is no 'Microsoft Text ODBC Driver' installation package to download. (if you know about an installation package URL you can contribute to the community by submitting the info to us through this message form)

Connection Strings

The Microsoft Text ODBC Driver driver can be used to connect to the following data sources by using the following connection string references:

Textfile