H
Herbert Chan
Hello,
I have a csv file that I want to get linked into a database. I have
Microsoft Office 2007. I use Excel to open it and everything is fine. I
try using Access to link it directly. I've been tinkering with the schema
and have overcome a number of obstacles. But there is this one that I
cannot overcome.
There is a field with the following kind of value:
78HB2035801
="78792000001"
="78792090101"
For some records, it has an equal sign at the front and wrapped by quotes.
For some there is no equal sign nor quotes.
Access can process the first kind of value (without anything in front and at
the back) for the field. When it encounters the second kind (with equal
sign and quotes), access can only extract = as the value of the field, and
then the rest of the fields after this problematic field all become blanks.
How should I treat such kind of values to enable Access to process every
fields in the record. This problematic field actually is of no use to me.
Any way to skip parsing this field such that Access can extract the fields
that I want?
Herbert
I have a csv file that I want to get linked into a database. I have
Microsoft Office 2007. I use Excel to open it and everything is fine. I
try using Access to link it directly. I've been tinkering with the schema
and have overcome a number of obstacles. But there is this one that I
cannot overcome.
There is a field with the following kind of value:
78HB2035801
="78792000001"
="78792090101"
For some records, it has an equal sign at the front and wrapped by quotes.
For some there is no equal sign nor quotes.
Access can process the first kind of value (without anything in front and at
the back) for the field. When it encounters the second kind (with equal
sign and quotes), access can only extract = as the value of the field, and
then the rest of the fields after this problematic field all become blanks.
How should I treat such kind of values to enable Access to process every
fields in the record. This problematic field actually is of no use to me.
Any way to skip parsing this field such that Access can extract the fields
that I want?
Herbert