Importing ascii file into datatable

[Guest]

I want to create a datatable from a text file.
Currently I open the file as a textstream and read one line at a time.
After reading each line I create a new row for my table and parse the line to
set the value for each item in my datarow. Then I add the datarow to the
datatble.
This works fine but is too slow.
I was looking for a way to import an ascii text file directly to a datatable
similar to the way you import into an excel spreadsheet where you define
fixed widths or some field seperator and then import the whole file in one
shot instead of line by line.
So far I haven't been able to find any bulk import method.
Any suggestions?

Regards,
Erik

 

[Darious Snell]

You might be able to setup a datareader using the texfile driver
and then do an insert query from the textfile into your datatable.

 

[W.G. Ryan eMVP]

Check out www.connectionstrings.com there's a connectionstring there for the
OleDbDataAdapter that should do it for you.

 

[Paul Clement]

¤ I want to create a datatable from a text file.
¤ Currently I open the file as a textstream and read one line at a time.
¤ After reading each line I create a new row for my table and parse the line to
¤ set the value for each item in my datarow. Then I add the datarow to the
¤ datatble.
¤ This works fine but is too slow.
¤ I was looking for a way to import an ascii text file directly to a datatable
¤ similar to the way you import into an excel spreadsheet where you define
¤ fixed widths or some field seperator and then import the whole file in one
¤ shot instead of line by line.
¤ So far I haven't been able to find any bulk import method.
¤ Any suggestions?

What is the format of the text file?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Cor Ligthert]

Eric,

When your file is a kind of csv you can use the oledbadapter and the
dataset.

In my opinion when it is a flat file, it has not much sense. Don't expect
that your reading will cost less time using the oledbadapter. That
dataadapter would have to read it as well.

Just my thought,

Cor