import informix data in other database appl
deven luk needed to get data out of an Informix application into an Access file, without special ODBC drivers if possible, because the app's only user was ill. Rudy Fernandes said the ODBC driver is in the free Client SDK. Leo Monroy described UNLOAD and LOAD to an ASCII file. Imran Hussain suggested WinSQL Professional. No outcome was reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
We have an application develloped by one of our collaborators in informix. The person is now heavily ill and as he is the only one who can use the application we are stuck. As we want to use the date, without changing anything to the program, i would like to retrieve the data in an ordinary access file. Is this possible without special odbc drivers ? If not where can i find these drivers ? Thanks for your help devenluk@hotmail.com
deven luk wrote: > We have an application develloped by one of our collaborators in informix. > The person is now heavily ill and as he is the only one who can use the > application we are stuck. As we want to use the date, without changing > anything to the program, i would like to retrieve the data in an ordinary > access file. > Is this possible without special odbc drivers ? If not where can i find > these drivers ? > > Thanks for your help > > devenluk@hotmail.com The ODBC driver is part of the Client SDK kit available free from http://www.intraware.com. Rudy
You can unload the data into and ascii file by using the Informix unload
command:
unload to "<path/filename.unl>" select * from <tablename>
to load the data back into the table type the following:
load from "<path/filename.unl>" insert into <tablename>
Good luck
deven luk wrote:
> We have an application develloped by one of our collaborators in informix.
> The person is now heavily ill and as he is the only one who can use the
> application we are stuck. As we want to use the date, without changing
> anything to the program, i would like to retrieve the data in an ordinary
> access file.
> Is this possible without special odbc drivers ? If not where can i find
> these drivers ?
>
> Thanks for your help
>
> devenluk@hotmail.com
Try WinSQL Professional at http://www.indus-soft.com/winsql
Leo Monroy wrote:
> You can unload the data into and ascii file by using the Informix unload
> command:
>
> unload to "<path/filename.unl>" select * from <tablename>>
> to load the data back into the table type the following:
>
> load from "<path/filename.unl>" insert into <tablename>>
> Good luck
>
> deven luk wrote:
>
> > We have an application develloped by one of our collaborators in informix.
> > The person is now heavily ill and as he is the only one who can use the
> > application we are stuck. As we want to use the date, without changing
> > anything to the program, i would like to retrieve the data in an ordinary
> > access file.
> > Is this possible without special odbc drivers ? If not where can i find
> > these drivers ?
> >
> > Thanks for your help
> >
> > devenluk@hotmail.com
--
=====================================================================
Imran Hussain
imranh@imranweb.com
For FREE Software visit
http://www.imranweb.com/freesoft
=====================================================================