Re: [PHP-DB] Access tables to PostgreSQL

2001-08-24 Thread Alexandre Santos

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP-DB] Access tables to PostgreSQL

2001-08-22 Thread Tim O'Brien

What is the best method to move data from access tables to postgreSQL?

Are there are php functions that are available?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] Access tables to PostgreSQL

2001-08-22 Thread grant

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.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]