I
Ian Oliver
I am importing text into Access 2007 like this:
"text1","text2.1";"text2.2","text3"
So the two fields separated by a semicolon are multiple values for the same
field.
Using a comma text separator and " delimiter the text import wizard show it
exactly how I want it with both sub-fields parsed in to the same field.
On actual import I 'Unparsable Record'.
Weird that Access understand this format but refuses to do it!
Any know way around this?
"text1","text2.1";"text2.2","text3"
So the two fields separated by a semicolon are multiple values for the same
field.
Using a comma text separator and " delimiter the text import wizard show it
exactly how I want it with both sub-fields parsed in to the same field.
On actual import I 'Unparsable Record'.
Weird that Access understand this format but refuses to do it!
Any know way around this?