| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What text format is this and can I import it into Postgres? |
| Date: | 2012-08-23 06:22:53 |
| Message-ID: | k14i7s$d13$1@ger.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mike Christensen, 23.08.2012 02:41:
> Oh, also if anyone knows of a way to export an Access database to
> Postgres, that might be helpful. I don't have a copy of Access.
If you have a Windows box, you can try SQL Workbench/J. Even though it is a Java application it can connect to an Access database using the JDBC/ODBC bridge. As every Windows box has an ODBC driver for Access built-in you don't need any additional drivers (you do need a Java runtime obviously).
An example connection URL is shown in the manual: http://www.sql-workbench.net/manual/profiles.html#odbc
On a 64bit System setting up the ODBC connection can be tricky though as both 32bit and 64bit drivers are registered I believe. The Java Runtime has to have the same "bits" as the ODBC driver in order to work.
I have no idea if using JDBC/ODBC would work on a Unix/Linux box though.
SQL Workbench can export any database it can connect to, to various output formats (http://www.sql-workbench.net/manual/command-export.html) The text/csv exports can be imported into Postgres.
Regards
Thomas
(I'm the author of SQL Workbench/J)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2012-08-23 07:04:02 | Re: At what point does a big table start becoming too big? |
| Previous Message | Thomas Kellerer | 2012-08-23 06:15:20 | Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL) |