Limiting fetched rows with OleDbConnection

  • Thread starter Thread starter Gene Hubert
  • Start date Start date
G

Gene Hubert

I'm using an OleDbConnection object to read a text file. It works
fine but what I really want to do is read a small sample from a very
large file. I'm looking for a way to limit the number of lines read
from the file.

I thought there might be something in the Extended Properties of the
connection string but can't find anything. I searched the online help
for "Extended Properties" and couldn't find a blasted thing.

Any help would be much appreciated.

Gene in NC
 
Hi Gene,

Generally, I use a streamreader to read through a text file and then I
extract data in segments from it. However, your question suggests you're
using a text driver. If this is so, couldn't you limit the read with
'select top 25 etc?

HTH,

Bernie Yaeger
 
Back
Top