Thread: 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:
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