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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ccall database and collect data from one table

I want to connect to one database and collect data from any table using shell script.

2. Shell Programming and Scripting

how to copy data to to excel file

Hi, Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column. Say my text file data is: 15-dec-2008 15-dec-2009 16-dec-2008 16-dec-2009 ...

3. Shell Programming and Scripting

store the table data in excel file

Hello - I have a below table and i want to extract the data into excel sheet and send to different location. Here is the table structure... SQL> desc t_i1_exportdocs Name Null? Type ----------------------------------------- --------...

4. Web Development

INSERT data to a Database Table from a text file

If you have a text file and if you want to Insert data to your Database Table, You can do it with these queries LOAD DATA LOCAL INFILE '/path/yourTextFile.txt' INTO TABLE yourTableName FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'

5. Shell Programming and Scripting

How to extract data into excel from a database in unix

Hello viewers, I am connecting to db2 database from unix. I am executing a query for example select * from emp. I need to export the data obtained from the above command to a excel file. Could you please suggest how to proceed on this? thanks and regards, k.n.v.santosh

6. Shell Programming and Scripting

KSH Script -- loop and data copy question

I am trying to write a script that will allow me to train others with commands that I run manually by only allowing the exact command before continuing onto the next set of commands. Here is where I come into an issue. I have changed the directories for this post. Software we run creates files...

7. Shell Programming and Scripting

Copy Data from CSV file to Excel Sheet using Perl

Hi All, Firstly I will like to wish A Happy New Year to all. Now my issue is I have one csv file say(data.csv) and one excel file say(result.xls) The result.xls contains two sheet name Sheet1 and Sheet2, Now What I am trying to do is to First I want to delete that data of Sheet2 if present any,...

8. Shell Programming and Scripting

Any Sample ksh script to validate all the database objects

Hi, I need a sample script to validate all the database objects like 1. table structure(columns, datatypes,key contraints if any) 2. synonyms 3. grants 4. indexes ....etc thank you!

9. 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.

10. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

LEARN ABOUT DEBIAN

test::aggregate::builder

Test::Aggregate::Builder(3pm)				User Contributed Perl Documentation			     Test::Aggregate::Builder(3pm)

NAME

       Test::Aggregate::Builder - Internal overrides for Test::Builder.

VERSION

       Version 0.364

SYNOPSIS

	   use Test::Aggregate::Builder;

DESCRIPTION

       WARNING:  This module is for internal use only.	DO NOT USE DIRECTLY.

AUTHOR

       Curtis Poe, "<ovid at cpan.org>"

BUGS

       Please report any bugs or feature requests to "bug-test-aggregate at rt.cpan.org", or through the web interface at
       http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Test-Aggregate <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Test-Aggregate>.  I will be
       notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

       You can find documentation for this module with the perldoc command.

	   perldoc Test::Aggregate

       You can also look for information at:

       o   AnnoCPAN: Annotated CPAN documentation

	   http://annocpan.org/dist/Test-Aggregate <http://annocpan.org/dist/Test-Aggregate>

       o   CPAN Ratings

	   http://cpanratings.perl.org/d/Test-Aggregate <http://cpanratings.perl.org/d/Test-Aggregate>

       o   RT: CPAN's request tracker

	   http://rt.cpan.org/NoAuth/Bugs.html?Dist=Test-Aggregate <http://rt.cpan.org/NoAuth/Bugs.html?Dist=Test-Aggregate>

       o   Search CPAN

	   http://search.cpan.org/dist/Test-Aggregate <http://search.cpan.org/dist/Test-Aggregate>

COPYRIGHT &; LICENSE
       Copyright 2007 Curtis "Ovid" Poe, all rights reserved.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.12.4							    2011-08-27					     Test::Aggregate::Builder(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ccall database and collect data from one table

Discussion started by: rinku

2. Shell Programming and Scripting

how to copy data to to excel file

Discussion started by: tucs_123

3. Shell Programming and Scripting

store the table data in excel file

Discussion started by: govindts

4. Web Development

INSERT data to a Database Table from a text file

Discussion started by: sitex