Re: importing informix db into MS-Access

>>Is it possible to import an INFORMIX Database into MS-Access and if so how? The main purpose is to get data into MS-Excel or Lotus 1-2-3. Figured MS-Access would be needed.<< You don't need access for this. All you must do is load the ODBC driver for Informix (along with the necessary networking stuff like INet & TCP/IP). MS Excel (Version 5) can talk to ODBC and bring your data directly into a spreadsheet or pivot table. I image that Lotus also has a similar option. In Excel you can create a program using VB if you wish to simplify the system for end users. One proviso, when issuing SQL calls from Excel there is a limit of 127 characters per SQL call. A simple work around for this is to send the SQL function an array of variants / strings, rather than one string. I hope this helps! -- Benjamin Taub Dataspace Incorporated, Ann Arbor, MI, USA PH: (313) 761-5962 FAX: (313) 761-5967