Delimited columns using Microsoft.Jet.OLEDB.4.0

Connection string

This Microsoft Jet OLE DB 4.0 connection string can be used for connections to Textfile.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;
Extended Properties="text;HDR=Yes;FMT=Delimited";

The delimiter can be specified in the registry at the following location:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Jet \ 4.0 \ Engines \ Text
"Format" = "TabDelimited"
or
"Format" = "Delimited(;)"

How to Use JET in 64 bit environments