L
LeAnn
To continue from a previous post - resolved previous issue but have yet a new
one with a different file but I believe they are similar. Using a Hex editor
I discovered that some files have lines ending with 0A only - which is
chr(10) I think (problem children) and some have lines in D0 0A - which is
chr(13) I think (angelic children). The way I solved the previous problem
was to use TransferText and then I ended up with 1 or 2 additional updates to
the imported records because I have to transform most of the fields and add a
field or two. While this worked, it is slow and inefficient. I have yet to
study about schema.ini files. Is a schema file a solution? Is it the only
way to solve my problem?
Thanks
LeAnn
one with a different file but I believe they are similar. Using a Hex editor
I discovered that some files have lines ending with 0A only - which is
chr(10) I think (problem children) and some have lines in D0 0A - which is
chr(13) I think (angelic children). The way I solved the previous problem
was to use TransferText and then I ended up with 1 or 2 additional updates to
the imported records because I have to transform most of the fields and add a
field or two. While this worked, it is slow and inefficient. I have yet to
study about schema.ini files. Is a schema file a solution? Is it the only
way to solve my problem?
Thanks
LeAnn