I need to write a program that imports data from .csv file into a database.
This was prev. being done through a dts that I created but the customers find it difficult to use the DTS even the documentation breaks it down very well.
I am more of a sql/vbs scripter than a .net programmer so please try not to laugh at me
I need to access the .csv file which was .xls just saved as a .csv it has two rows
row1 = workspaces
row2 = extensions
I need to loop through row 1 and grab the workspaces and insert them into 7 tables
r2 will be done the same way but inserted into 3 tables
how do I access the .csv file and how should I create those loops
please don't just tell the class can you also give me sample sytax on how to use the class
Thank you in advance