Table extraction/conversion from Informix SE 2.0 (1989)

Amsterdam, December 6. 1998 Hi, Does anybody knows what should be the proper way of importing tables from an Informix SE 2.0 database (1989) into MS-Access, or ASCII ? For a customer, I am developing an ordering system in MS-Access, and I should include the tables from his old system. This old system is an Informix SE 2.0 RDBMS from 1989 running under XENIX on a 386. I don't have access to this engine, but I have a total backup available on my NT/95 computer. The data is about 23 MBytes big. I spend already quit some time experimenting with the following methods: 1. Using Data Junction. This program often shifts the first byte (or so it seems) to a separate column. This can be manually corrected for ASCII fields, but not for numerical fields since the latter a totally messed up now (e.g. converting '12' to '-5,4378439E-53'. 2. Using ODBC, drivers/routines offered by e.g. Intersolve, Easysoft, OpenLink. 3. Using Data Exchanger or Datatalk These programs are ODBC-based (or so I think), and therefore may not add so much, especially when you just, just want to import some silly tables. 4. Trying to read the raw format. As mentioned, text fields aren't that hard. The problem is that I may need the raw format for the numerical fields, and write a conversion program myself in C or MATLAB. ***** This should be a pretty easy question (I guess), but I am already spending so much time on it, that I am really hoping that someone can just point me in the right direction. Plain table convertion shouldn't be that difficult?? Much thanks in advance, Jeroen Strompf ----------------------------------------------------------- Jeroen Strompf - Pengo Information Technology Niels Bohrweg 1, 2333 CA LEIDEN The Netherlands Tel.: +31 71 527 7096 +31 6 50 243 451 Fax: +31 71 527 6985 jstrompf@soil.nl -----------------------------------------------------------