Re: access data conversion

Posted in 1998

Art S. Kagel — Fri, 14 Aug 1998 10:33:50 -0400 — source: Informix-list mailing list archive (1991-1998)

Matt Devlin wrote: > > I have a databse designed in access that is becoming to large to stay on > that platform. I want to develop it in informix and use access, or perhaps > html (asp) as a front end. In the informix version I also want to alter the > design slightly by breaking the tables down a little more. My question is > what is the best method for getting the existing data into the informix > database? Should I build an exact replica in informix and make the > adjustments after the im,port or no? That might be the easiest way then you can just export to ASCII delimited format from access and LOAD the files into Informix. You will then have many options for the reorg. Art S. Kagel