table import from MS Access ? -Reply

Posted in 1997

Sky Southwell — 4 Apr 1997 16:08:21 -0500 — source: Informix-list mailing list archive (1991-1998)

Well, if you have an Access ODBC driver, and access to Delphi, you can use the 'DataPump'. I have used this several times, and it is fairly easy to set up, and fairly performant. Just remember to drop your destination indexes prior to 'pumping'. -- Sky +-------(southwel@smtpgw.maricopa.gov)-------+- Maricopa County -+ | Schuyler L. Southwell | Attorney's Office | | Data Management Consultant | 301 W. Jefferson | | Voice: 602-506-1111 **** FAX: 602-506-3970 | Phoenix, AZ 85003 | +--------------------------------------------+-------------------+ >>> Bert Schmidt <schmidt@cityweb.cww.de> 04/03/97 07:49am >>> I have to copy some tables from a MS Access database on a PC to an Informix Illustra database on a UNIX machine. Now I'm doing that by an textexport (ascii-file) on the PC and a textimport on the illustra server. Does anybody know an easier way? Is there a tool which can do an automatic synchronysation between tables on MS Access and Informix Illustra? Bert Schmidt