Re: Converting from .MDB Access to PostgreSQL

From: Chris Albertson <chrisalbertson90278(at)yahoo(dot)com>
To: "Bob Puff(at)NLE" <bob(at)nleaudio(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Converting from .MDB Access to PostgreSQL
Date: 2002-07-10 00:54:08
Message-ID: 20020710005408.30374.qmail@web14702.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm sure you can get MS Access to dump its data into a
comma or pipe delimited ASCII file. If so, Postgresql's
COPY command (see "man copy") can read these files. It is
mostly painless unless there are many tables.

--- "Bob Puff(at)NLE" <bob(at)nleaudio(dot)com> wrote:
<SNIP>
>

>
> I assume there are two distinct functions that need to be done:
> 1. Create the databases, with the appropriate tables and columns
> 2. Move the data within the database.
>
> I did do some searching on the site, but most of the stuff didn't
> quite "click". Any advice given
> would be greatly appreciated. Thanks!
>
> Bob
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

=====
Chris Albertson
Home: 310-376-1029 chrisalbertson90278(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)org

__________________________________________________
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-07-10 02:06:44 Re: Redhat/glibc and postgre time "bug"
Previous Message ljb 2002-07-10 00:42:13 Re: Frontend/backend protocol: authentication