Re: Exchange ACCESS <--> Informix

Posted in 1996

Nils Myklebust — Mon, 24 Jun 1996 12:02:20 GMT — source: Informix-list mailing list archive (1991-1998)

Kr'ger <100725.3355@compuserve.com> wrote: >Date: 24.06.1996 >From: Oliver Henning, Hamburg (Germany) >Re: Exchange ACCESS <--> Informix >Hi there ! >Does anyone know of a good solution to transfer data between ACCESS and >Informix in both directions ? Does it work with ODBC and how would that >work out in detail, because I'm no expert on that area ? You better RTFM some (on Access), but yes, ODBC is one solution. Of course you can also use unload and load functions in both databases. They are compatible enough that you can use the standard built inn functions in both for this. If you use ODBC you may find you do not need to transfer the data at all. You can easily access the data in your Informix database directly from MS Access. This of course assumes the databases are connected via some nettwork where you can run ODBC (a TCP/IP network). Do read you Access manuals on how to connect to external ODBC databases (or ask in the MS Access newsgroup). Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company