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
  • 2147

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


Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.