Citation

       "Please support us to improve our products and solutions. Give us your feedback."

Related Content

Related Contacts

Frank Daske, Business Development Manager

Frank Daske, Business Development Manager +49 (0) 40 28 41 12 - 30 sales@layer2.de

Related Downloads

pdf Image2009-11-01: Layer2 Press Release

SharePoint – New Business Data List Connector for External Lists in MOSS 2007 and WSS 3.0
Layer2, the SharePoint Experts from Hamburg (Germany) announced a new Microsoft SharePoint extension to unlock the value of enterprise data for SharePoint 2007 based portals. The Business Data List Connector (BDLC) for SharePoint directly connects SharePoint lists with external LOB data sources. Almost any data from databases, Office or even text data can be displayed in SharePoint lists without any programming. Workflows can be used to start business actions in SharePoint, if external data records are changed.

xml ImageBusiness Data List Connector PAD File

This XML-based PAD file offers a BDLC product description for resellers to download and publish.

pdf ImageFlyer: Layer2 Partner Program

Partner with us as a software reseller or SharePoint service provider. There is a free partner program with up to 30% discount. Download as PDF.

Related Links

Are you looking for Layer2 product resellers and implementation partners?

United States:

Great Britain, Scotland and Ireland:

France:

Netherlands:

Switzerland:​

Poland:

Turkey:

South Africa:

Malaysia:

BDLC works with NINTEX Workflow 2010 for SharePoint

Start NINTEX Workflows while external data changes.

Main Content

Claim

The valid syntax of the select statements depends on the types of data sources used. Below there are given some samples for Microsoft Excel data sources, that are often used with the SharePoint Business Data List Connector (BDLC).

 Excel data pull to SharePoint list

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

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.