Informix to MS Access

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

bryan007@my-dejanews.com — Fri, 15 Jan 1999 19:07:27 GMT — source: Informix-list mailing list archive (1991-1998)

I am using Informix 7.1.2 (which does not support ODBC) running on Windows NT 4.0, and want to transport my data to MS Access. Is there any way of doing that except moving the data into a flat file and then importing it into Access everytime. Any help would highly be appreciated. Thanks Ted Thomas -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

↪ replying to bryan007@my-dejanews.com

David Meyer — Fri, 15 Jan 1999 13:02:09 -0700 — source: Informix-list mailing list archive (1991-1998)

Ted, I don't understand your statement (does not support ODBC) but with ACCESS you can: FILE -- IMPORT --- GET EXTERNAL DATA -- IMPORT and connect to Informix through ODBC. For the record you can also transfer your data from ACCESS to Informix within ACCESS by: RIGHT CLICK ON TABLE -- EXPORT -- TO EXTERNAL FILE OR DATABASE -- SAVE AS TYPE ODBC -- OK -- SELECT ODBC CONNECTION. Of course you must have ODBC configured for your database. David Meyer Guerilla Software www.webulate.com bryan007@my-dejanews.com wrote in message <77o3l6$o6t$1@nnrp1.dejanews.com>... >I am using Informix 7.1.2 (which does not support ODBC) running on Windows NT >4.0, and want to transport my data to MS Access. Is there any way of doing >that except moving the data into a flat file and then importing it into Access >everytime. > >Any help would highly be appreciated. > >Thanks > >Ted Thomas > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own