Tag Info

Personally, I would use PowerShell. But, if you really must use BCS, look at the samples for creating a custom BSC Connector to XML, XLS, or CSV. There are several out there. Scot Hillier wrote the book and there are samples in there: http://www.amazon.com/Professional-Business-Connectivity-Services-SharePoint/dp/047061790X Once you have the BCS connection ...

Add the following to DOCICON.XML (default location is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML) <Mapping Key="csv" Value="icxltx.png" OpenControl=""/> Then in IIS Manager select the server and then select MIME Types, update the entry for csv to 'application/vnd.ms-excel'. This will allow you to click the ...

In the lack of more details concerning the possibilities would work for you (e.g. looking at custom development or a no-code solution), i would the easiest is to use the BDC via SharePoint Designer to load from external source according to your schema. The major point here is what possibilities you have: could you bulk-export to some data store accessible by ...