Re: Databases, Typed Datasets, and Flat Files oh my!
- From: "Marina" <someone@xxxxxxxxxx>
- Date: Wed, 7 Sep 2005 16:41:47 -0400
As far as I know, there is no way to do this other then to manually read the
file, get the right characters, and then manually add the rows to the
dataset or database. There is no built in mechanism I am aware of us to
process these kinds of files.
"Ben" <spamdrop@xxxxxxxxxxxx> wrote in message
news:1126124243.488799.292370@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> So, at my place of employment, we use a national standard to transmit
> data between certain applications. This standard consists of a fixed
> width, flat file 4500-some-odd chars wide that contain 375-some-odd
> columns (Not delimited). This standard is not changing anytime soon, so
> I attempting to write a library of some sort to read and write these
> files within our SQL databases (which use 160 of those columns, but
> completely ignore the rest).
>
> Now, the way I would attempt to understand this is: Flat file gets
> sucked into dataset, dataset gets shoved into database (or vicea
> versa). So... All of the stuff I see for typed datasets is "XML! XML!
> XML!" but I'm just looking at a way of specifying a dataset in which
> there is a table that says "Field1 is chars 1-10, Field2 is chars
> 10-14..." etc etc etc.
>
> So, people infinitely more talented then me, how would you attempt to
> do this?
>
.
- References:
- Prev by Date: Re: Determine Language of Outlook folders?
- Next by Date: Re: Hide Columns in a datagrid
- Previous by thread: Databases, Typed Datasets, and Flat Files oh my!
- Next by thread: Re: Databases, Typed Datasets, and Flat Files oh my!
- Index(es):
Relevant Pages
|
