another INSERT issue

[Dave]

Access 2003
Excel 2003
I was recently helped a lot here with issues I was having pulling data from
EXCEL and INSERTing into an Access table.
One of the things mentioned was to use
Replace(strMyText, "'","''")
incase there was a quote in the text being imported.

I am now having an issue with an asterisk (*) in the text being imported.
I tried using the Replace() but it did not work (or more then likely I did
it wrong)

Any suggestions on how to deal with an asterisk in a text field in EXCEL
being inserted into an ACCESS Table?

Any help here will be appreciated.

Thanks in advance
Dave

 

[Douglas J. Steele]

Replace(strMyText, "*","")

 

[Mike Painter]

I've not seen a replacement problem with an asterisk but not all symbols are
as the appear.
"-" for example seems to have at least two ASCII codes that show the same
thing and "..." may be three periods or a code that looks like three periods
but is a single symbol.