ziggynorton,
You should be able to import/link the XL file directly in Access, assuming
it has a table structure. The fact you have commas in a text field should
not matter.
Even so, with the CSV file, as long as your memo field is surrounded by
quotes (which it would be if generated by XL), again the internal commas
should not matter, as long as you tell Access that the Text Qualifier is ""
(on the first step of the Access Import Wizard click Advanced..).

Why will the XL file not import directly ?

NickHK

"ziggynorton"
wrote in message
...

Hi, my first post!
I have a workbook which I need to change into a comma delimited file so
as to import it into Access (it won't import with the normal xls file
but it's ALMOST right if I use csv). It works fine until I try to
import memo fields containing a comma, wherein it uses the comma to
create a new cell. What I want to do is to have all the commas removed
from the memo fields. I did find a piece of code which should do this
but have no idea how to implement it. Any suggestions gratefully
received. Thanks. Ziggy.


--
ziggynorton
------------------------------------------------------------------------
ziggynorton's Profile:
http://www.excelforum.com/member.php...o&userid=35210
View this thread: http://www.excelforum.com/showthread...hreadid=551751