INFORMIX -> Access Script
Posted in 1995
Topics: General Discussion
Does anyone know an easy way to import the schema from an INFORMIX database to an MS Access system. I know there are differances such as DECIMAL(x,y) to SINGLE and the removal of "NOT NULL", but how do you actually feed a schema into Access - it's poxy Query editor only seems to allow one SQL statement at a time - the ";" delimiter does not work.. <moan> :( I'm probably missing something here, but I don't want to have to hand create queries for each table in the system :((( I already have sed scripts to strip out all the junk such as the usernames/DBSCHEMA messages etc, so I could in theory produce a script of some sort Does anyone have any ideas about how I should do this. Ideally someone already has a program/script to do this :))) - If I could even do it via another program it would be great. :) If anyone has any ideas, could you send some eMail to me since I don't always get my Usenet feed. All the best, // tbone@home in Ireland