Re: Newbie Question on Informix/ViewPoint

Gina Scott wrote: > > Hi I was wondering if anyone could help me? > > I have a Btrieve database and I need to convert/export/import all the > data from all of the tables to an Informix/SQL database using ViewPoint. > > I was wondering of an easy way or any way to complete this task, please? If you can export the btrieve databases to either delimited files or fixed field length ASCII you can import them into Informix using either the dbload utility or dbaccess->Query->New->"load from <file> insert into <table>". Dbload can handle either delimited or fixed field while the dbaccess load command can import delimited files only. (N.B. - Informix expects the last field to end in a delimiter preceding the EOL character(s), many ASCII delimited export utilities do not delimit the last field so you may have to post process the files before importing them.) Art S. Kagel