Re: Migrate MsAccess Query to PostgreSQL

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Raymond Tsang" <RaymondT(at)bluechipit(dot)com(dot)au>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Migrate MsAccess Query to PostgreSQL
Date: 2002-08-05 07:26:55
Message-ID: D85C66DA59BA044EB96AB9683819CF61137FF2@dogbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Raymond Tsang [mailto:RaymondT(at)bluechipit(dot)com(dot)au]
> Sent: 05 August 2002 08:13
> To: pgadmin-support(at)postgresql(dot)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.

Browse pgadmin-support by date

  From Date Subject
Next Message Raymond Tsang 2002-08-05 23:08:14 Failed to create View after Access migration
Previous Message Dave Page 2002-08-05 07:25:51 Re: Module not found on connection