A few years ago, an application I was working had a requirement to import an excel spreadsheet into SQL. I had written tons of office interop code in Delphi and C#, but all of them always created spreadsheets from data, never really the other way around.
My 1st stab at doing it (the lazy way), was to create a SQL 2000 DTS package which imported the spreadsheet into a SQL Table and then executed the package from code (SQL 2000 implementation). This needed the DTS libraries installed on each of the target machines the application would be used on as well as special DB privileges for each of the users allowing them to execute the DTS package. Not ideal.
So when I got around to converting the system from Delphi to .NET, I decided to give the Excel reading thing a go. I mean, .NET is awesome….right? It must have some really cool…
View original post 267 more words