I really have 2 very similiar problems importing data into MS Acess 2000.

Problem #1.)  
Data looks like this:
"xxx","xxxx","123","xxxxxxxxxxxxxxxxx","1234"
"xxx","xxxx","123",""WI"xxxxxxxxxxxxx","1234"

Column 4 of Record 2 causes the error message "Unparsable Record".
I've tried putting in an escape character "\"WI\"xxxxxxxxxxxxx", but that 
didn't help.


Problem #2.)
Data looks like this:
"2E82"    <-- defined as a text field

But is loaded into access as this:
2.00E+82  <-- it's wrongly been converted to scientific notation

Any help would be appreciated.

Hai,

Problem #1
while importing text files separated by comma
whatever string shown within double quotes will be imported as  a field.
Fundamental principle:
1) complete string quoted within double quote will be taken as a field
2) If you want to retain double quotes within another double quote it will
not be possible. Error msg will come.
3) You can have single quoted string within double quoted string or double
quoted string within single quoted string.
ex. "WIXXXXXXXX"           ---  DISPLAY WILL BE     WIXXXXXXX
      "'WI'XXXXXXX"            --- display will be           'WI'XXXXXXX
      '"WI"XXXXXXX'           -----DISPLAY WILL BE     "WI"XXXXXXX
      "[WI]XXXXXXX"          ------DISPLAY WILL BE    [WI]XXXXXXX

4) so doubles quote within double quotes is not allowed for representing a
single field/column

Problem #2

When we  quote within double quote (ie "2E82") it will be construed as  a
string and the imported field in access will show only 2E82.
If you show as 2E82 without any double quote it would be taken as
double/float. So you get scientific notation in the imported field.

Even in Excel you will get the same problem if you don't start with single
quote.

murugan.
   


-------Original Message-------

From: Access
Date: Thursday, January 01, 1970 05:30:00 AM
To: Access
Subject: [access] Problems importing double quoted csv with double quotes
inside the data

I really have 2 very similiar problems importing data into MS Acess 2000.

Problem #1.) 
Data looks like this:
"xxx","xxxx","123","xxxxxxxxxxxxxxxxx","1234"
"xxx","xxxx","123",""WI"xxxxxxxxxxxxx","1234"

Column 4 of Record 2 causes the error message "Unparsable Record".
I've tried putting in an escape character "\"WI\"xxxxxxxxxxxxx", but that 
didn't help.


Problem #2.)
Data looks like this:
"2E82" <-- defined as a text field

But is loaded into access as this:
2.00E+82 <-- it's wrongly been converted to scientific notation

Any help would be appreciated.
.