Text import not WYSIWYG

[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?

 

[Jeff Boyce]

Are you saying that you want Access to stuff more than one fact into a
(single) field? If so, stop now! A common premise of good database design
is "one fact, one field".

If you are trying to stuff multiple values into a single field, your table
structure would probably benefit from further normalization.

After all, Access' relationally-oriented features and functions work best
with well-normalized data.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.