From: Randy Dees <[EMAIL PROTECTED]> Subject: Access database from PostgreSQL? I have just read the wonderful concise directions for accessing a PostgreSQL database from MS Access, and just wondered: does anyone have a procedure for accessing the Access database from Postgres? I'm not likely to get the MS group here to relinquish control of that database so that I can put it in Postgres native, but I'd really like to use their data in our own databases. Thanks Randy, I am testing this stuff too. . . I first CREATED a table with fields mirroring the existing msaccess table using psql (but you can create table in the SQL view of a msaccess query too. . .) on our linux box, and then in my msaccess database I linked to BOTH the new postgresql table and the existing msaccess table. Then use the INSERT INTO statement with SELECT to copy from the access table into the pgres table. Check your msaccess help topics for INSERT INTO for the syntax of the statement (or use an SQL book or the POSTGRESQL documentation). Seemed to work fine for me. Might for you too. JT
