I am importing a delimited ASCII text file into a dataset using OLEDB.
I set up the connection and dataadapter and then fill the dataset.
It works - sort of.
It turns out that some of my data is omitted. Specifically, one of the
columns is set to Int32, but the data is really string.
The first few rows of data have numeric valus in this field but further down
there are some letters mixed in with the numbers. So only fields with pure
numbers are imported.
I tried building the table in code before importing and specifying this
field as String.
The import occurred but the data was still missing.
Seems like the import process is deciding things for me "behind the scenes".
Any ideas how to get all the data loaded?
Would it help if I put string data in that column in the first row of data?
Would the import then "guess" that the column datatype is string and not
Int32?
How would I handle this since for an arbitrary file which may not have
string data in that column in row 1?
--
Joe Fallon