Re: access data conversion

Posted in 1998

insight@shabakah.com — Fri, 14 Aug 1998 22:38:02 +0300 — source: Informix-list mailing list archive (1991-1998)

We have tried using CLI, just export Access database to ODBC and choose CLI. -----Original Message----- From: Art S. Kagel <kagel@bloomberg.net> To: informix-list@iiug.org <informix-list@iiug.org> Date: Friday, August 14, 1998 10:01 ' Subject: Re: access data conversion >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