Re: MSaccess--->SQL

From: "John Foulds" <j.foulds@home.com> > >Just a quick Q. > >I have a flat MS Access file, just tables, no relationships, indexes, >triggers, or procedures that I have to port to Informix. > >What is the easiest way to end up with an Informix DB? I'm sure we'll get a WinSQL post on this one, but I think simpler and easier *might* actually be to make your Informix table, set up an ODBC link to the Informix table and just use Access to copy the rows from one table to another. Or just "insert into informixtable select * from accesstable"... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com