Hello and how are things I am looking to find the best way to get to an excel file sheet data. I want to query this data the bets and most efficient way out there today. I have an SQL 2005 server and I want to pass from my C# 2.0 program using Application Blocks, the Select command to query the data that is in an Excel file sheet. I know there is Jet that was used, but wonder is that the only way to do this with an OLE jet connection?
Should I maybe look at converting this to XML would that be better? Thanks :)