create tables in PostgresQL with Access

[Rosco4]

Can anyone outline the code I would use to create new tables in a PostgresQL database using MS Access 2003. Thank you.

 

[Pat Hartman]

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]

thx

Thanks, Pat. This is exactly what I needed to know to get started. It worked perfectly!