Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to extract data into excel from a database in unix
Top Forums Shell Programming and Scripting How to extract data into excel from a database in unix Post 302497081 by joeyg on Wednesday 16th of February 2011 09:23:13 AM
Old 02-16-2011
Writing to an Excel file layout is possible, but can be complicated and requires add-ons.
One way many write to Excel is to create csv files. For instance, if you create a file called output.csv:

output.csv
Code:
smith,200,10
barry,300,12
harry,12,2001

Excel would read this as a spreadsheet with three rows of data, each row with three columns. Would this accomplish what you want?
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

2. Shell Programming and Scripting

Need shell script to extract data from oracle database

shell script (4 Replies)
Discussion started by: frns5
4 Replies

3. Shell Programming and Scripting

Help on email data file as excel from unix!!

Hi, I need to email a data in excel sheet from unix using shell scripting.I could able to generate the data file with tab delimiter with extension .xls could able to email it. The problem is when a coulmn with 16 digit number is exported, it is showing in scientific format. Any help in... (1 Reply)
Discussion started by: sparan_peddu
1 Replies

4. Shell Programming and Scripting

Sample ksh script for copy the data from excel to database table ?

Hi All, I need to convert the data from excel to database table in sybase. Please provide some sample script.. thanks, Royal. (1 Reply)
Discussion started by: royal9482
1 Replies

5. Shell Programming and Scripting

how to extract the data from database (oracle) and send the output as an .xls file?

Hi, How to extract the data from Oracle database and sent the output data to mails using mailx command with .xls attachement? Here i know how to connect the database using unix shell script and how to use the mailx command in UNIX script But i don't know how to use the .xls format file (i... (1 Reply)
Discussion started by: psiva_arul
1 Replies

6. Programming

How to extract data from CVS log files and store it in database ?

Am currently working on CVS projects .. I have generated the cvs log file which is in the RCS file format . .I want to extract file path ,total revision ,date ,author and message from that file . .I want a program in java which would extract the data from cvs log file. .Pls help me out.. My... (0 Replies)
Discussion started by: EVERSOFT
0 Replies

7. Shell Programming and Scripting

Export data from database in Excel sheet with the help of Shell script and automated the report

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies

8. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

Hi, i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks Regards, Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies

9. UNIX for Dummies Questions & Answers

How to extract UNIX output to excel CSV file?

Hi guys - I have a file and output like this below: File: myfile.dat File has content like this: ABCD, 34, 456, 2324 I would like excel to have this: Name (ABCD) Quantity (34), Type (456), Status (2324) (Name, Quantity, Type and Status are columns) I would like to export... (4 Replies)
Discussion started by: DallasT
4 Replies

10. UNIX for Beginners Questions & Answers

Extract UNIX data to excel

Hi, I would like to extract the data from particular date, 1. may i know which command i need to use? 2. Extract from unix command (those extracted above) to excel? Please assist. Thanks (2 Replies)
Discussion started by: Peru
2 Replies

LEARN ABOUT REDHAT

drop_database

DROP 
DATABASE(7)						   SQL Commands 						  DROP DATABASE(7)

NAME

       DROP DATABASE - remove a database

SYNOPSIS

       DROP DATABASE name

   INPUTS
       name   The name of an existing database to remove.

   OUTPUTS
       DROP DATABASE
	      This message is returned if the command is successful.

       DROP DATABASE: cannot be executed on the currently open database
	      You  cannot  be connected to the database you are about to remove.  Instead, connect to template1 or any other database and run this
	      command again.

       DROP DATABASE: may not be called in a transaction block
	      You must finish the transaction in progress before you can call this command.

DESCRIPTION

       DROP DATABASE removes the catalog entries for an existing database and deletes the directory containing the data.  It can only be  executed
       by the database owner (usually the user that created it).

       DROP DATABASE cannot be undone. Use it with care!

   NOTES
       This  command  cannot  be executed while connected to the target database. Thus, it might be more convenient to use the shell script dropdb
       [dropdb(1)], which is a wrapper around this command, instead.

       Refer to CREATE DATABASE [create_database(7)] for information on how to create a database.

COMPATIBILITY

   SQL92
       DROP DATABASE statement is a PostgreSQL language extension; there is no such command in SQL92.

SQL - Language Statements					    2002-11-22							  DROP DATABASE(7)
All times are GMT -4. The time now is 09:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy