Exporting and Inporting a table
This is a multi-part message in MIME format. ------=_NextPart_000_0057_01C2C0A6.C3C336D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, Can you tell me how i can export a table from an informix database in = excel format and after that how can I imported? Best Regards, =20 Cristian Beniuga ------=_NextPart_000_0057_01C2C0A6.C3C336D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#c0c0c0> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Can you tell me how i can export a = table from an=20 informix database in excel format and after that how can I=20 imported?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Best Regards,<BR> <BR>Cristian=20 Beniuga<BR></FONT></DIV></BODY></HTML> ------=_NextPart_000_0057_01C2C0A6.C3C336D0--
export
DBDELIMITER=","
dbexport database
cd database.exp
for x in `ls *.unl`
do
fname=`echo $x | cut -d"." -f1`
mv $x $fname.csv
done
get the files to your excel environment.
Open them.
Oh - sorry - did you want column headers so Excel will know the column (err
field) names? Then you'd have to use dbaccess and the 'output' option
(unless I'm forgetting and that was only there for isql).
Did you want to import them from excel?
Alternatively you could use the connect product to open the tables directly
from Excel. I haven't done that yet - so don't ask me.
cheers
j.
----- Original Message -----
From: "Beniuga Cri...." <ben@mindcti.com>
To: <ids@iiug.org>
Sent: Monday, January 20, 2003 10:08 AM
Subject: Exporting and Inporting a table [44]
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0057_01C2C0A6.C3C336D0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi all,
>
> Can you tell me how i can export a table from an informix database in =
> excel format and after that how can I imported?
>