Обсуждение: import msaccess stuff into pgccess-standalone desktop

was talking with someone online and they mentioned getting ODBC for
msaccess and them exporting my database with that and importing ( with
postgres-odbc installed) them somehow into postgres via pgaccess?????

that would be loverly if possible but are there ( assuming this is
possible)
special directions to be aware of to pull this off??

thx
lee

Get the Postgres ODBC driver for windoze (probably in your distro
already), and install it to point to your Postgres server.  Open
msaccess and Export your tables one at a time to the ODBC connection.
You don't need pgaccess for this....

>>  was talking with someone online and they mentioned getting ODBC for
>>  msaccess and them exporting my database with that and importing (
>> with postgres-odbc installed) them somehow into postgres via
>> pgaccess?????
>>
>>  that would be loverly if possible but are there ( assuming this is
>>  possible)
>>  special directions to be aware of to pull this off??
>>
>>  thx
>>  lee
>>
>>
>>
>>  ---------------------------(end of
>> broadcast)--------------------------- TIP 4: Don't 'kill -9' the
>> postmaster

--
terry

I just exported the access tables as tab delimited files and used the
plug-in in pgadminll to load it into PostgreSQL. There's a little
learning curve but it all seemed pretty intuitive.

lee johnson wrote:

> was talking with someone online and they mentioned getting ODBC for
> msaccess and them exporting my database with that and importing ( with
> postgres-odbc installed) them somehow into postgres via pgaccess?????
>
> that would be loverly if possible but are there ( assuming this is
> possible)
> special directions to be aware of to pull this off??
>
> thx
> lee
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>

sorry let me refine this situation some..i'm using msaccess for my companies invoicing needs and looking for a best way scenario to start doing this in linux..i do not have a server on either linux or windows system ie: standalone machines albeit im thinking of hooking up a network to get both machines access to broadband without having to switch cables all the time <G> so thats an option if its one I need ?..anyway thats why I mentioned pgaccess as it has a 'interface' to postgres so I can start setting up a UI similar to what I had in msaccess to start the ball rolling at least...

thx
lee
-===

terry wrote:

Get the Postgres ODBC driver for windoze (probably in your distro 
already), and install it to point to your Postgres server.  Open 
msaccess and Export your tables one at a time to the ODBC connection.  
You don't need pgaccess for this....
 

 was talking with someone online and they mentioned getting ODBC formsaccess and them exporting my database with that and importing (
with postgres-odbc installed) them somehow into postgres via
pgaccess?????
that would be loverly if possible but are there ( assuming this ispossible)special directions to be aware of to pull this off??
thxlee


---------------------------(end of
broadcast)--------------------------- TIP 4: Don't 'kill -9' the
postmaster     

oh okay did search for pgadmin II and I see now..okay here's hoping this
new database migration gets the job done....

thx
:)
lee
-====

Rodger Haynes wrote:

> I just exported the access tables as tab delimited files and used the
> plug-in in pgadminll to load it into PostgreSQL. There's a little
> learning curve but it all seemed pretty intuitive.
>
> lee johnson wrote:
>
>> was talking with someone online and they mentioned getting ODBC for
>> msaccess and them exporting my database with that and importing (
>> with postgres-odbc installed) them somehow into postgres via
>> pgaccess?????
>>
>> that would be loverly if possible but are there ( assuming this is
>> possible)
>> special directions to be aware of to pull this off??
>>
>> thx
>> lee
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Don't 'kill -9' the postmaster
>>
>>
>
>
> .
>

> -----Original Message-----
> From: Rodger Haynes [mailto:rodger@thompsonprint.com]
> Sent: 10 September 2002 18:20
> To: lee johnson; pgsql-odbc
> Subject: Re: [ODBC] import msaccess stuff into
> pgccess-standalone desktop
>
>
> I just exported the access tables as tab delimited files and used the
> plug-in in pgadminll to load it into PostgreSQL. There's a little
> learning curve but it all seemed pretty intuitive.

The pgAdmin Migration Wizard can normally handle .mdbs without the
intermediate stage.

www.pgadmin.org

Regards, Dave.

--- lee johnson <lee@imyourhandiman.com> wrote:
> sorry let me refine this situation some..i'm using
> msaccess for my
> companies invoicing needs and looking for a best way
> scenario to start
> doing this in linux..> ?..anyway thats why I
mentioned pgaccess as it has a
> 'interface' to
> postgres so I can start setting up a UI similar to
> what I had in
> msaccess to start the ball rolling at least...
>
You can still use MS Access as a front end to
PostgreSQL.  Just migrate the tables in one of the
ways suggested, then just delete all of your Access
tables and link to the tables in the PostgreSQL
database (you may want to test this with a copy of
your .mdb file first :-) ).

__________________________________________________
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute