Problem inserting text field with quotes and other special charact

L

Lavu

I am trying to add records to a SQL server db from access VBA.
One of the fields in the record is a text field that is filled with the
entire contents of a text file. This text file has a lot of special
characters including quotes that cause my INSERT statement to fail. I need to
send the
"set quoted_identifier off" statement to SQL server to enable to text to be
inserted as it is.
Any ideas on how to do this or any alternate method would be appreciated.

Thanks in advance.
 

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

Problem inserting text field with special characters and quotes 0
Moving Large text field into SQL server from ACCESS2000 0
Problem with text field containing special characters/quotes 0
Field Name with Special Characters 1
TransferDatabase ToSQL 6
Double quotes within text cause unparsable record error 2
Parse text string and insert characters 5
Concatenate Text Fields to Date Field 5

Top