Re: Porting from MS Access 2007 to PostgreSQL

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(dot)klaver(at)gmail(dot)com