Limiting fetched rows with OleDbConnection

[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

[Bernie Yaeger]

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
"Gene Hubert" <gw******@hotma il.com> wrote in message
news:3f******** ********@news-server.nc.rr.co m...

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

[Herfried K. Wagner [MVP]]

Hello,

"Gene Hubert" <gw******@hotma il.com> schrieb:

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.

Why don't use the functions contained in the 'System.IO' namespace to read
the file?

Basic code for reading the lines of a file:

\\\
Imports System.IO
..
..
..
Dim sr As New StreamReader("C :\WINDOWS\WIN.I NI")
Dim strLine As String
strLine = sr.ReadLine()
Do Until strLine Is Nothing
MsgBox(strLine)
strLine = sr.ReadLine()
Loop
sr.Close()
///

You can extend the sample by adding a line counter and stop reading after
reading n lines.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet