Delimited text not importing correctly!! This is weird

[memaxt]

Hi all

I have a csv file with one row of data containing delimited text via a comma

Example



1, James, Smith, Manchester, email, telephone, notes etc..

Think there are 50 comma separations all together.

Anyway when I go to import / link my csv into access the data that is on the first row should it create individual fields where a comma has been placed... But it has doesnt quite worked, some of the fields are created and the rest have been put on a separate row! Rather than going to a new field.

Rather having 50 fields I've got 21 fields and 3 rows or delimited text... HELP

[June7]

Want to provide the csv file for analysis? Follow instructions at bottom of my post.

[memaxt]

Please find attached CSV file

Apologies there now commas there semi-colons i've used...anyway

It contains 4 fields, 3 of which are non delimited and the 4th field contains lots delimited data, As you will notice, I have wrote ;this is a test;this is a test;this is a test between the semi-colons,



but when importsonme of the data goes onto seperate rows.

[June7]

I set the Text Qualifier option to " and the line then imported/linked as a single record with 5 fields.