VB.Net - CSV to Oracle table
Posted on 2016-11-19
I am stuck and looking at examples, but cannot find any good examples of how to read a csv file and loading the data into an oracle table. Most examples I found indicate using sqlloader or toad, but I want an application so I can retrieve what's been loaded and do some data comparison for the users to review after the load. So this VB.Net tool will allow the users to select the csv file and load into oracle table. Most rows they will be loading is about 200 rows or less, so performance will not be an issue.
The csv file and oracle table will have the same columns/fields:
Customer Name, Address, City, State, Zipcode
The oracle table name is "CUSTOMER_ADDRESS".
Can someone with experience how to read from csv to Oracle table give me an example?