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!

extracting data to .xls or .csv format

Status
Not open for further replies.
060159

060159

Technical User
Feb 19, 2004
54
GB
not sure I am in the right place, but here goes. I want to extract all of the data from our kalamazoo database to excel, and I have been told that I need to spend thousands of pounds on something called Oracle - surely this cannot be so? Is there a simple method I can use? Thanks in great anticipation!
 
Sort by date Sort by votes
what software are you using for your database? How many tables, columns, and rows do you have? Probably the most important question is why do you want to export the whole database to excel?
 
Upvote 0 Downvote
You can use a comma delimiter to spool the results into a .csv file. And the question is not clear about what is the source and the method of extract. please clarify it.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

multipledatabases
  • Locked
  • Question
How to bulk import a CSV or a TXT file trough command into a Teradata database
Replies
1
Views
289
Miguel93
Miguel93
Samm2020
  • Locked
  • Question
Oracle to Teradata for data source setup
Replies
1
Views
151
johnherman
johnherman
tmcrouse
  • Locked
  • Question
tough time with a teradata date format
Replies
0
Views
134
tmcrouse
tmcrouse
Teamalone
  • Locked
  • Question
How to export multiple files using teradata tpt
Replies
0
Views
170
Teamalone
Teamalone
2009luca
  • Locked
  • Question
date format
Replies
0
Views
99
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top