I need some way to read in an Excel 2007 file (xlsx or xls) to a SQL database. What's the best method to do this? Do I convert to XML first? Can I read in an XLS file instead? Or is there a more suitable format to convert to? The Excel file contains a very large table too large to print (except in large format printing). All I want is to store this data in a database that, when queried, returns the same data in a table, but in different ways. And are there some sample C# code that I could use, at least to show how to read the file in and write it to the database? I can do everything else. I'm using SQL server 2008 Developer edition. Thanks.
View Complete Post