Problem inserting text field with special characters and quotes

[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.