Insert data from excel files to database table
Posted by:
yilinglim
Date: July 20, 2004 11:41PM
is there any way to Insert data from excel files to database table directly without editing the data in order to avoid the mistakes when editing it ??
there is over 50,000 lines of data in the excels file. So, it really took quite a long time for me to edit it become insert query and finally done.
but the output of the data (sum of the value) are not tally with the excel files ! so, this really make me headache !!
any help would be appreciated..
Subject
Views
Written By
Posted
Insert data from excel files to database table
35576
July 20, 2004 11:41PM
21815
July 21, 2004 12:35AM
12011
July 21, 2004 01:45AM
19489
July 21, 2004 02:54AM
12210
July 21, 2004 03:33AM
9387
July 21, 2004 04:54AM
7913
May 02, 2008 01:36AM
9956
December 09, 2005 07:52AM
5433
March 25, 2009 10:54PM
6549
June 22, 2006 07:29PM
6577
January 30, 2006 07:51AM
5533
November 08, 2008 02:28AM
5548
January 22, 2009 12:19PM
6402
February 24, 2009 03:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.