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

Providers

Microsoft Jet OLE DB 4.0 .NET Framework Data Provider for OLE DB .NET Framework Data Provider for ODBC .NET txtReader for Text Files

Articles

read all »
Jet for Access, Excel and Txt on 64 bit systems The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine Formating Rules for Connection Strings Connection Strings Explained Store Connection String in Web.config Connection Pooling The Provider Keyword, ProgID, Versioning and COM CLSID Explained Store and read connection string in appsettings.json SQL Server Data Types Reference Network Protocol for SQL Server Connection