Re: [GENERAL] double quotes inside VBA string ?

[Sim Zacks]

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ć" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... 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 ?