another INSERT issue

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WORD VBA Search and switch to advanced ... 1
Page numbering with Merged Document and IF statements 1
Modern equivalent of Autotext in Word? 0
Access 2003 and excel 0
Synchronization problems while moving folders to new email 1
Working on birthday "book" for my wife and having layout/editing trouble 0
VBA Syntax issue (I hope) 7
Copy and Paste Special in Excel #REF error 1

Top