How to use textfile in Microsoft Jet OLE DB 4.0
In this Article i will explain you About how to use OLE DB in Text Files
Introduction
It is a computer file that contains text (and possibly formatting instructions) using seven-bit ASCII characters and it is use in OLE DB using this code.
Code
Use Of Delimited columns
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\txtFiles\;Extended Properties="text;HDR=Yes;FMT=Delimited"
|
Use of Fixed length columns
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\txtFiles\;Extended Properties="text;HDR=Yes;FMT=Fixed";
|
You may also want to read these related articles :
here
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answer here