Read text file character by character

[skylabnn]

Please help me.
I want to read a text file(.txt) character by character into a database.
There are 28 characters on each line and I want to read the first 16 into a column in a database and the rest in another column in the database.

Please help me (VB.NET code)
Thank you

 

[jmcilhinney]

Why would you not eat the first 6 doughnuts in a dozen? Wouldn't you want to just eat them all?

A very unrealistic example, I know.

 

[skylabnn]

Thanks guys. I know it's unrealistic but I want to to give the users the ability to choose the number of rows to import. I have sorted that out with a variable in a For Loop.
Please how can I reduce the time it takes to import?

It takes too long to import say 100,000 rows.

Thanks

 

[MattP]

It takes too long to import say 100,000 rows.

You've got 2 options. Make the files smaller or put the data in a relational database.