another INSERT issue

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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.
 
Back
Top