pk2(at)o2(dot)pl wrote:
> Generally I would like to have the same possibility to make an:
> INSERT INTO [Postgres_server].mydatabase.user.mytable
> (id, data1, data2, data3)
> SELECT
> id, data1, data2, data3
> FROM [remote_mssql].remotedatabase.dbo.table2
The quick solution (and the one I always use) is to setup ODBC for
postgresql, then create an MS-Access database that links to both. Add a
bunch of queries/vba and you're done.
--
Richard Huxton
Archonet Ltd