Thread: Migrate MsAccess Query to PostgreSQL

Migrate MsAccess Query to PostgreSQL

From
"Raymond Tsang"
Date:
Hi,

Is there a simply way to migrate my Access Queries into the PostgreSQL? I
tried cut and paste from the SQL views of Access but I got errors.

Regards,

Raymond Tsang
Business Development Manager
Bluechip Infotech Pty Ltd
P: (02) 8745 8434
F: (02) 8745 8499
raymondt@bluechipit.com.au
http://www.bluechipit.com.au


Re: Migrate MsAccess Query to PostgreSQL

From
"Dave Page"
Date:

> -----Original Message-----
> From: Raymond Tsang [mailto:RaymondT@bluechipit.com.au]
> Sent: 05 August 2002 08:13
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Migrate MsAccess Query to PostgreSQL
>
>
> Hi,
>
> Is there a simply way to migrate my Access Queries into the
> PostgreSQL? I tried cut and paste from the SQL views of
> Access but I got errors.

Depends what syntax you have used. PostgreSQL won't understand [ ] as
quotes for example, so you may need to do a little manual hacking of the
code.

Regards, Dave.