How can we Consume Excel sheet data to create External List using BCS in sharepoiont 2010, .net Assembly connectors.?
I need to create External List using BCS in sharepoint 2010 . I have the functionality to consume XML file but can anybody guide me to use a Excel spreadsheet as a data source. I dont want to use "importFromSpreadsheet" template available in sharepoint.
How can we Consume Excel sheet data to create External List using BCS in sharepoiont 2010, .net Assembly connectors.?
===

I need to create External List using BCS in sharepoint 2010 . I have the functionality to consume XML file but can anybody guide me to use a Excel spreadsheet as a data source. I dont want to use "importFromSpreadsheet" template available in sharepoint.