Export Table to Excel Sheet
Hello, im wondering, this:
I have one table, and i want to export it to a CSV file.I know how to use the select * from table INTO OUTFILE '/tmp/test.txt', BUT Thats not the problem.
For Example:
TABLE users
------------
id names
1 jerry
2 michael
i want this table ordered by fields in CSV, but all appears in the first COLUMN of the excel....
CSV FIELDS
-----------
A1=1 jerry
A2=2 michael
So, how can i put the data, ordered in each field of the excel ?.... like this:
CSV FIELDS
-----------
A1=1 B1=jerry
A2=2 B2=michael
My email is
victorzp86@hotmail.com, THANK YOU VERY MUCH.
Subject
Views
Written By
Posted
Export Table to Excel Sheet
11495
May 17, 2011 11:35PM
3868
May 18, 2011 12:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.