Re: double quotes inside VBA string ?

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(dot)matic1(at)sb(dot)t-com(dot)hr> 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 ?
>
>