Re: MS Access to Informix conversion
Posted in 1998
Madison Pruet — — source: Informix-list mailing list archive (1991-1998)
I think that if you use the MSaccess and create a query using the data
that you want to copy, you can then click on File->Export-> Save type as
text file but leave formated unchecked->export->delimited->other "|"
with text qualified set to none... If this is done, then you should be
creating a file that can be used by the dbaccess load command.
Tim Leahy wrote:
> I need to upload about seven Access97 tables into a Informix
> database. Does anyone know of any utilities or a short program
> that I can write to transfer the Access tables to Informix. I
> have the Informix SDK and I'm looking through that now but I was
> wondering if anyone knew and quick solutions.
>
> Thanks,
> Tim Leahy