Re: Access to postgres conversion

Hi.

You could try /Access to PostgreSQL /from Bullzip.com. I liked the dump
file that this creates. Small neat and it is free!

Tommy.

> It's 10 tables. that's all. No reports. I will follow your
> suggestion. Thanks for the help
>
> On Wed, May 25, 2011 at 4:25 PM, John R Pierce <pierce(at)hogranch(dot)com
> <mailto:pierce(at)hogranch(dot)com>> wrote:
>
> On 05/25/11 12:42 PM, akp geek wrote:
>
> Dear all -
>
> I would like to know if any one has migrated
> database from MS access to Postgres . We use postgres 9.0.2 on
> solaris . Are there any open source tools that you have used
> to do this task. Can you please share your experiences ?
>
>
> how many tables is this database? is there more to it than just
> tables? (Access isn't really a database, its a data-centric rapid
> application development system). postgres won't do the reports,
> forms, macros, etc (ok, it has user definable
> procedures/functions, but they aren't in vbasic, and they don't
> work anything like access programs do).
>
> if its just a few tables, it might just be easiest to dump those
> tables as CSV files, then import them one by one into equivalent
> tables in postgres via COPY FROM
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>