writing content of csv files into oracle
-
i am just starting with c# and wondering if there is a way to read the contents of csv files stored in a particular folder on network and write it into an oracle table. Can someone give me an example so that i can try and test by myself.
-
i am just starting with c# and wondering if there is a way to read the contents of csv files stored in a particular folder on network and write it into an oracle table. Can someone give me an example so that i can try and test by myself.
-
i am just starting with c# and wondering if there is a way to read the contents of csv files stored in a particular folder on network and write it into an oracle table. Can someone give me an example so that i can try and test by myself.
To add to what Richard has said, there are several CSV reading packages - this one reads into a DataTable, so provided the columns match up with your database, they can be INSERTed with no other changes: A Fast CSV Reader[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
-
To add to what Richard has said, there are several CSV reading packages - this one reads into a DataTable, so provided the columns match up with your database, they can be INSERTed with no other changes: A Fast CSV Reader[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!
