Re: Moving DB from MS Access to Informix

In <32222268.5CA2@teir.com> Mark Meytin <mmeytin@teir.com> writes: >Hello! >I'm desperately looking for a way to move an Access database to >Informix. Can anybody lend a clue on how to do this? I'm able to >create delimited text file from Access, but how do I pass all >the tables and fields info to Informix, and what Informix utility >do I use to import? I can't seem to figure out a way to create >a plain text DDL file in Access... Any help is much appreciated! >Thanks in advance, dbload [-d dbname] [-c cfilname] [-l logfile] [-e errnum] [-n nnum] [-i inum] [-s] [-p] [-r] -d database name -c command file name -l bad row(s) log file -e bad row(s) # before abort -s syntax error check only -n # of row(s) before commit -p prompt to commit or not on abort -i # or row(s) to ignore before starting -r loading without locking table Check the syntax of the command file in the manuals. [ cc. to poster ] -- Clay Irving N2VKG clay@panix.com http://www.panix.com/~clay/