Re: importing informix db into MS-Access

Benjamin Taub (74557.3255@CompuServe.COM) wrote: : >>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! If you are using Excel 5.0, it comes with MS-query. You can use this to get data from Informix to Excel through ODBC and I-Net. Nguyen Nguyen