470,647 Members | 1,248 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Excel 97 Export to Postgres

Need to export an existing M$ Access 97 database to Postgres.

Tuples must be filtered as I am using sequences and other constraints.

Help from anyone that has experience with this or know of 3rd party automation
tools would be greatly appreciated.

Raymond

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #1
1 1993
On Tuesday 26 August 2003 09:10 am, Raymond wrote:
Need to export an existing M$ Access 97 database to Postgres.

Tuples must be filtered as I am using sequences and other constraints.

Help from anyone that has experience with this or know of 3rd party
automation tools would be greatly appreciated.

Raymond

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


My suggestion:

If you're migrating to an empty PostgreSQL database:
1. Create the constraints in MS Access. If the process errors out, find and
fix the violations.
2. Link the target tables in PostgreSQL into the Access database via ODBC.
5. Run an append query to copy the Access data to PostgreSQL.

If you're moving data into an existing PostgreSQL database:
1. Link the target tables in PostgreSQL into the Access database via ODBC.
2. Create a "conflict" char field in the Access database tables.
3. Run an update query in Access to update the conflict fields with a "1"
where the record in Access matches a PostgreSQL record in a way that violates
the existing constraints.
4. Fix the conflicts in the Access tables.
5. Run an append query to copy the Access data to PostgreSQL.

I don't think you need anymore automation than this. Unless you are willing
to lose data in the migration, there is no way to get around finding and
fixing constraint violations.

Best of luck,

Andrew Gould

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matt | last post: by
21 posts views Thread by bobh | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
5 posts views Thread by Simon | last post: by
15 posts views Thread by patf | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.