SQL Help

Posted in 2001

Phil Moirris — Wed, 7 Feb 2001 08:01:41 -0000 — source: Informix-list mailing list archive (1991-1998)

A question from a complete novice, How can I get the results from an informix sql in a format that I can import into MS Excel or MS Access, ie with some form of delimiter. Thanks Phil Morris

↪ replying to Phil Moirris

Debbie Caswell — Wed, 7 Feb 2001 09:45:27 -0000 — source: Informix-list mailing list archive (1991-1998)

You can use the UNLOAD command e.g. UNLOAD TO filename DELIMITER "," SELECT ....... > -----Original Message----- > From: Phil Moirris [mailto:Phil.Morris@u-net.com] > Posted At: 07 February 2001 08:02 > Posted To: informix > Conversation: SQL Help > Subject: SQL Help > > > A question from a complete novice, How can I get the results from an > informix sql in a format that I can import into MS Excel or > MS Access, ie > with some form of delimiter. > Thanks > Phil Morris > >

↪ replying to Phil Moirris

Art S. Kagel — Wed, 07 Feb 2001 18:44:58 -0500 — source: Informix-list mailing list archive (1991-1998)

Th dbaccess unload command is usually OK. You may do better by getting Jonathan Leffler's sqlcmd package from the IIUG Software Repository. Sqlcmd can output true .csv format including column headings and optionally data types. Art S. Kagel Phil Moirris wrote: > > A question from a complete novice, How can I get the results from an > informix sql in a format that I can import into MS Excel or MS Access, ie > with some form of delimiter. > Thanks > Phil Morris