Re: double quotes inside VBA string ?

Pascual De Ruvo <deruvo@xxxxxxxxx> · Wed, 18 May 2005 09:34:09 -0400

If you need to use a double quote inside a VB string, you have to write two double quotes (double double quotes!),

so your command will  be something like:

"select * from 
public.""Customers"""

On 5/18/05, Zlatko Matić <zlatko.matic1@xxxxxxxxxxx> wrote:

Hello.
I have a 
problem when working with MS Access/PostgreSQL. 
Namely,  
as PostgreSQL syntax uses doble quotes for table names and field 
names,  when I write it as a string of a pass-through query or Command text 
of ADO Command object it looks like:
"select * from 
public."Customers""
and VBA considers that the first quote after public. 
is the end of statement.

How to solve it 
?