Transmit a table to Access 2000.

Posted in 2004

Michael Andreas — Tue, 9 Mar 2004 13:56:48 +0100 — source: Usenet: comp.databases.informix

Hi, who can tell me the right INSERT INTO-command to transmit a complete table from informix to Access2000. I test the following string - but the access-connection is not right INSERT INTO [Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\DataBase.mdb].vorg SELECT * FROM vorg; Where is the error? thanks michael