Re: Problem with Importing CSV with "=" inside a field value
- From: "Jellifish" <J.Ellifish@xxxxxxxxxxx>
- Date: Fri, 10 Apr 2009 22:54:55 +0100
I would import the values as text and sort them out in the table using
replace functions in update queries.
"Herbert Chan" <herbert@xxxxxxxx> wrote in message
news:O0gqfqbuJHA.4980@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- Problem with Importing CSV with "=" inside a field value
- From: Herbert Chan
- Problem with Importing CSV with "=" inside a field value
- Prev by Date: Re: Text on Multiple Rows of Text File
- Next by Date: Re: Troubleshoot Date in Linked Excel file
- Previous by thread: Re: Problem with Importing CSV with "=" inside a field value
- Index(es):
Relevant Pages
|
