Thread: migration from acess to postgres
12-06-05, 02:16 #1Registered User
- Join Date
- Dec 2005
Unanswered: migration from acess to postgres
I tried to export an existing database from MSAccess by right-clicking on the table and saying "export".
I had an open connection port 5432, username, password all set and was able to connect using ODBC- PostGres ANSI.
The table got exported alright and i am able to see it using PGAdmin III.
the data in the table did not get exported. So its a blank table in the database with correct number, name and type of columns but no data in it....
There were no error msgs...
Is this the was it is supposed to be?
How do i get the actual data in the tables then?
How do i get the actual data in the tables?
please help... (desperation)
tia, any more info required pl. ask.
12-14-05, 12:35 #2Registered User
- Join Date
- Sep 2001
the easiest and dirty way is
create the tables in postgres
link the tables create in postgres through the odbc driver and copy and paste the data from access to the linked tables in postgreshttp://www.postgresql.org
--Postgresql is the only kind of thing--