Insert data from Excel to oracle in

Posted by Ashpal under VB.NET on 5/29/2014 | Points: 10 | Views : 1461 | Status : [Member] | Replies : 1

I have to load data from excel to oracle tables.
When I am selecting data from excel datasheet with
"Select * from [Data$]"
I am getting empty rows. I have 20170 rows but it is selecting 20264/20265 with 94/95 extra empty rows.
Can I avoid this with changing my query or I have to write a condition?

Thank for you help.



Posted by: Vuyiswamb on: 7/7/2014 [Member] [MVP] [Administrator] NotApplicable | Points: 25

make your Query to look like this

Select * from [Data$] where Column NOT ([Column] = '' OR [DOB*] IS NULL OR ... )

change the Column to the name of the Column in Excel

Thank you for posting at Dotnetfunda

Ashpal, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response