M
Moe
I am trying to import a text file into access. I set up the external file as
comma Delimitted with ' " ' as text qualifier and comma as field separator.
But Access takes some of the commas that are inside the text as field
separator. It does not do this to all the commas for example "firstName,
lastName" is recognized fine but "..cars, truks and trains...." is broken
into two fields as "cars" and "truks and trains." Now, this happens on the
fields that are Memo type but not on all of the Memo fields. It is not
related to the length of the field either, some larger fields with commas
included in them are being recognized just fine. When I changed the text
separator from Comma to Under Score " _ " again similar problem happened but
this time several fields were getting combined in to one field. How can I
solve this problem without VBA?
comma Delimitted with ' " ' as text qualifier and comma as field separator.
But Access takes some of the commas that are inside the text as field
separator. It does not do this to all the commas for example "firstName,
lastName" is recognized fine but "..cars, truks and trains...." is broken
into two fields as "cars" and "truks and trains." Now, this happens on the
fields that are Memo type but not on all of the Memo fields. It is not
related to the length of the field either, some larger fields with commas
included in them are being recognized just fine. When I changed the text
separator from Comma to Under Score " _ " again similar problem happened but
this time several fields were getting combined in to one field. How can I
solve this problem without VBA?