Binding an excel file to a DataGridView in C# and VS2005

TowerMan

Hi I wish to display the data in an excel spread sheet in a DataGridView. I am coding in c# and using Visual Studio 2005. I have created a excel spread sheet called Excel Test. Then I add a DataGridView to my form and when it prompts me to add a new data source I select new connection. I then change the data source to Microsoft OBDC data source as it seems to be the only one that will allow me pick an excel file. I then change the user/ system file to Excel files and then I build the connection to point to the excel file, I then hit the test connection button and it produces a succesful test connection. I then ok to that and it directs me to choose Database objects. From a list it gives me the option of picking Tables, views, etc. I select all and then finish. But nothing appears in my gridview. In the option of picking my Database objects in the Tables section it does not expand so it seems that there is nothing in the excel speadsheet. I have got this working for both an access and sql database. I am setting it up correctly?

Evil Phil

Of the top of my head you'll have to set up named ranges (at least one) within the spreadsheet and select from them instead of your traditional database table names.