Hi,
I don't know if I'm using the correct terminology, but I'm trying to use a unit test, or just a C# class file to pull records from an excel file(sheet) and insert them into a sql Database. Does anyone know of a good tutorial, book, or any resource at all I could learn how to do this. Also what this action is called. I'm saying Unit test because that's what I use at work all the time. The project I'm working on is all C# Class Files, no asp.net files at all. So I kind of need a class file for this as well. Eventually after I get this set up, I would like to repeat this action with any excel file that needs to be inserted into my Database.
Thanks, any help would be appreciated.
I'm also doing this in visual studio 2012. FYI.