Insert data from Excel to oracle in Vb.net

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

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.

Ashpal




Responses

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

Up
0
Down
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
[Administrator]

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

Login to post response