Re: Porting from MS Access 2007 to PostgreSQL - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Porting from MS Access 2007 to PostgreSQL
Date
Msg-id 201011090706.06674.adrian.klaver@gmail.com
Whole thread Raw
In response to Porting from MS Access 2007 to PostgreSQL  (Victor Hooi <victorhooi@yahoo.com>)
List pgsql-general
On Monday 08 November 2010 8:22:51 pm Victor Hooi wrote:
> Hi,
>
> Disclaimer: Not a DBA, nor I am not a DB guy, so please excuse any
> ignorance in the below.

>
> *4. MS Access to Postgres*
>
> Anyhow, somebody else suggested it might be better to just go straight from
> the original MS Access database to PostgreSQL.
>
> My first question is, what is the current recommended procedure for this?
>

One way I have done this is to use the Make Table Query in Access to create a
table in Postgres from one in Access. This assumes you have an ODBC connection
set up to Postgres.

> Cheers,
> Victor



--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Full Vacuum/Reindex vs autovacuum
Next
From: Josh Kupershmidt
Date:
Subject: Re: REINDEX requirement?