RE: access data conversion

Matt, I've transfered my access database table by table to the informix database through ODBC connection. The steps are as follows: setup informix odbc data source select the table in access database File --> Save As/Export... to external database Save Type: ODBC database Select the approperiate data source It transfers both data and data structures to the informix database Regards Naibin > ---------- > From: Matt Devlin[SMTP:mhdevlin@nycap.rr.com] > Reply To: Matt Devlin > Sent: Friday, August 14, 1998 8:27 PM > To: informix-list@iiug.org > Subject: access data conversion > > 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? > >