How to create a valid OLEDB select statement in SharePoint for Excel as external data source?


While integrating external data sources into SharePoint via OLEDB the valid syntax of the select statements depends on the types of data sources used. Below are given some samples for Microsoft Excel data sources that are often used with the Layer2 Business Data List Connector for SharePoint (BDLC).



Excel connection to SharePoint



Please take a look at the following examples:


1. "SELECT * FROM [Sheet1$A:E]"   


2. "SELECT * FROM [Sales$A:E] WHERE Name='Bob'"   


Name being the column heading which will get treated as a recordset field.



How to connect to Ecxel via OleDb in detail:

MS Excel Use Case

How to connect to MS Access via OleDb in detail:
MS Access Use Case


Layer2 leading solutions product regsitration icon: a grey square with a big orange pen symbol.

Register for free download.

Keep your Sharepoint in sync. Download and try today.

Contact Us Icon for Layer2 leading solutions

Questions? Contact us.

We are here to help. Contact us and our consulting will be happy to answer your questions.