Re: Access tables to PostgreSQL
| From: | Alexandre Santos | Date: | Fri, 24 Aug 2001 18:42:56 +0000 |
| Subject: | Re: Access tables to PostgreSQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11815@lists.php.net to get a copy of this message | ||
Grant wrote:
>
> On Wed, 22 Aug 2001, Tim O'Brien wrote:
>
> > What is the best method to move data from access tables to postgreSQL?
> >
> > Are there are php functions that are available?
> >
> Unfortunately, only Access reads Access very well, but you can use ODBC
> and linked tables in Access to copy it to PostgreSQL.
I copied tables from Access to Postgres using this method:
1. Install the ODBC Driver in your Windows Box.
2. Export the tables to Postgres.
If the second pass doesn't work, create the tables in POstgres and then
link them in Access and build a append query that copies all the
information from the acess tables to the postgres tables.
Alex