Filling a DataSet from a positionally delimited flat file

  • Thread starter Thread starter billym
  • Start date Start date
B

billym

An article in the The Code Project entitled "A simple architecture to read
arbitrarily formatted flat files into ADO DataSets" had the following
comment:

"There are Ole Providers to read formatted flat files into DataSets, but
ever wondered about importing data from files which are not simply comma
delimited or tab delimited (not columnar) but some native format."

Does anyone have a link to information on these providers? (All of my
reference material only shows how to access databases such as SQL Server,
Oracle, Access, etc.)
 
Hi. I think you first need to determine the structure of stored data and
then you can construct a DataSet around it using
System.IO.StreamReader to read the file and System.String to get the
appropriates substrings.

I don't know of other Data Providers than OleDb , ODBC, SQL and Oracle. at
least not from Microsoft.

alex.
 
I created a class that can populate a DataSet from a positionally delimitted
file based on info in a Cobol copybook... but was curious about the
statement in The Code Project that seemed to indicate this was not
necessary.

BizTalk has good support for flat files, but this will not work in my case
insofar as I am building a Tablet PC application and BT would be overkill.
 
Back
Top