Insert data from Excel to oracle in Vb.net

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts