Re: Newbie Question on Informix/ViewPoint

Hey, that was what I was going to say.... Scoobs "Whatever it is I think I see, becomes a bunch of code to me....." Art S. Kagel wrote: > 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