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