Problem with Importing CSV with "=" inside a field value
- From: "Herbert Chan" <herbert@xxxxxxxx>
- Date: Fri, 10 Apr 2009 16:59:06 +0800
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
.
- Follow-Ups:
- Re: Problem with Importing CSV with "=" inside a field value
- From: Jellifish
- Re: Problem with Importing CSV with "=" inside a field value
- From: Roger Carlson
- Re: Problem with Importing CSV with "=" inside a field value
- Prev by Date: Re: To export data from Access 2003 to Excel 2007
- Next by Date: Re: To export data from Access 2003 to Excel 2007
- Previous by thread: To export data from Access 2003 to Excel 2007
- Next by thread: Re: Problem with Importing CSV with "=" inside a field value
- Index(es):
Relevant Pages
|
