View Full Version : create tables in PostgresQL with Access


Rosco4
08-20-2004, 02:17 PM
Can anyone outline the code I would use to create new tables in a PostgresQL database using MS Access 2003. Thank you.

Pat Hartman
08-21-2004, 08:41 PM
Assuming that there is an ODBC driver available for PostgresQL, you would need to use whatever SQL variant that PostgresQL supports to create the necessary DDL. Once you created the CREATE TABLE SQL statements, you would run them from Access as pass-through queries.

Rosco4
08-23-2004, 07:50 AM
Thanks, Pat. This is exactly what I needed to know to get started. It worked perfectly!