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 Data to Excel

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hi All,
Pls help me.
I want to export data from Table in Excel sheet through coding how can I do that ?
 
Sort by date Sort by votes
Hi,

Create a comma separated values file (csv file) like this.

Select col1 || ',' || col2 || ',' || col3

that will read straight into Excel
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
133
mmiah1982
mmiah1982
Bill Doe
  • Locked
  • Question
PDO UPDATE too long to execute
Replies
1
Views
130
mikrom
mikrom
fredong
  • Locked
  • Question
Update upper row data with next row data that was detached partially from import.
Replies
6
Views
180
carp
carp
szeiss
  • Locked
  • Question
Need to select the one value if it exists otherwise another value
Replies
4
Views
144
szeiss
szeiss
Junior6202
  • Locked
  • Question
String or binary data would be truncated.
Replies
1
Views
99
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top