Re: How to import Informix into MS Access?

Chris Drauch wrote: > [SNIP] > > Isn't so simple. How to convert data types like dec/date etc without the > C-ISAM developer kit? > > -- > Chris Drauch > Chris, True. Money fields, and decimal fields do use a dec_t structure, but that information is readily available. (Just ask someone to post the include files for esql/c which detail the data structure.) [Then for date calculations, you would need to count the number of days from DEC 31, 1899. [Day 0] Just add the date to a base variable.] BTW, 4.10 is the SE. Since you want to read the records to another database, you can forget the *.idx files. The hardest part is determining what data is in what field. To convert the data, you would have to know the length of each field, and the data type. You would also have to be good with od so you can look at decimal, date , and other numeric fields. -Mikey [Sounds like I've done this before right?]