Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Sql Table Data to Ms-Excel

Status
Not open for further replies.
taqmeena

taqmeena

Programmer
Mar 22, 2005
53
PK
How Can we Export Data of Table From Sql To Microsoft Excel using SQL 8.0 and Forms 6i

Please Give Details.
 
Sort by date Sort by votes
If you are using client/server you should use TEXT_IO from forms to create a comma-delimited file (csv) that can be imported directly to Excel. From SQLPlus you can use SPOOL to create an output file in the same way.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

deo1
  • Locked
  • Question
Please help with forms6i ole2 ms word
Replies
0
Views
123
deo1
deo1
faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
148
oradba101
oradba101
taqmeena
  • Locked
  • Question
Exporting Sql8 Table Data to Ms-Excel
Replies
1
Views
32
lewisp
lewisp
millzy7
  • Locked
  • Question
Table Relationships
Replies
1
Views
77
BJCooperIT
BJCooperIT
phish20002003
  • Locked
  • Question
SQL Question
Replies
1
Views
51
alwaysAnewbie
alwaysAnewbie

Part and Inventory Search

Sponsor

Back
Top