[AccessD] commas in comma delimited data

Two situations.  commas in Text....Yes, just use a text delimiter, such as
double quotes.  Then access will ignore any commas in double quoted text.

The other situation, would be if you were using a number system which uses
the comma instead of the period for a decimal point.  Not sure how to get
around that one....

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Colby, John
Sent: Tuesday, August 17, 2004 2:17 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] commas in comma delimited data


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.

JWC