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
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 ?