Re: double quotes inside VBA string ?

["Sim Zacks" <sim@xxxxxxxxxxxxxx>]

double up the double quotes.  "select * from public.""Customers"""

In any case, I agree with jeff, make your table names lowercase and leave out the quotes.

 

Sim

"Zlatko Matić" <zlatko.matic1@xxxxxxxxxxx> wrote in message 001d01c55bab$87607cf0$99301dc3@zlatkovyfkpgz6">news:001d01c55bab$87607cf0$99301dc3@zlatkovyfkpgz6...

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 ?