B
BostonNole
I am looking for suggestions on the most efficient way to import 7
different fixed width files into a DataSet. Not all at the same time.
One file at a time, but the format could change from file to file.
I have 7 (and more coming) different fixed width files that my clients
provide to me, within each one the field sizes and ordering is slightly
different...maddening I know.
Each file could possibly be as large as 150 MG with around 70,000
records in them.
I need to be able to import these files into a DataSet so I can do
further requirements/validation checking on certain fields.
I've looked at FileHelpers (http://filehelpers.sf.net) and
TextFileParser and neither one will do what I need to do.
Any suggestions?
different fixed width files into a DataSet. Not all at the same time.
One file at a time, but the format could change from file to file.
I have 7 (and more coming) different fixed width files that my clients
provide to me, within each one the field sizes and ordering is slightly
different...maddening I know.
Each file could possibly be as large as 150 MG with around 70,000
records in them.
I need to be able to import these files into a DataSet so I can do
further requirements/validation checking on certain fields.
I've looked at FileHelpers (http://filehelpers.sf.net) and
TextFileParser and neither one will do what I need to do.
Any suggestions?