[AccessD] commas in comma delimited data

Gustav Brock gustav at cactus.dk
Wed Aug 18 04:33:32 CDT 2004


Hi John

The preferred way is to surround non-numerics by double quotes:

..,"27 Heath Way, #27",456,"Colby, John",..

/gustav


> Is there some "break" character that I can place in front of or around a
> comma to tell Access' wizard that links comma delimited files that a comma
> is not a field separator but a real data in the data?

> IOW 

> 27 Heath Way, #27 turns into two fields when imported (skewing the data)
> where I really want to pull the data into a single field.

> I can replace the comma with a tab but would like to solve this problem for
> the future.




More information about the AccessD mailing list