Re: Informix - Word, Excel & VB
Posted in 1997
Mark Bennet wrote
> I work for a small manufaturing company and we have a need to transfer
> small items of data from our Informix database (SCO 5) to Word, Excel
> and VB programs, for reports, graphs etc.. and I don't know where to
> start.
> Any suggestions would be much appreciated.
If you don't have ODBC to get the data direct from Informix, you can always
use UNLOAD to do it.
Use isql or dbaccess with the command:
UNLOAD TO "filename" SELECT * FROM tabname
This will give you an ASCII file that you can import to Word, Excel or VB.
Also if you need any special delimiter, like tab, you can add that
to the unload command.
HTH
Serafim Fonseca
==========================================================================
Serafim Fonseca e-mail: sf@dpx20.growela.pt
Growela Portuguesa Calcado, Lda. phone : +351 2 9820510
S. Pedro Avioso, Castelo fax : +351 2 9812212
4470 Maia - PORTUGAL