SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need put the SQL table (with over 20000 records) into a SharePoint list, and use it in InfoPath.

share|improve this question

You can use BCS with an external content type to access your SQL table from a SharePoint list. There are limitations such as you can't export to Excel, and there may be limitations with InfoPath too.

You can use a PowerShell script or content import tool to import the data from SQL to SharePoint. E.g. export the table as a csv and iterate through each row to add a list.

There are multiple methods to getting external data into InfoPath, not just a SP List. See this MSDN link for more information:

share|improve this answer

The simplest of the ways that I can think right now is to export the sql server table data into an excel sheet and then import this excel data into a list (Site Actions >> View All Site Content >> Create >> Import Spreadsheet). Ah, by the way excel stops at 21730 maximum lines. So I told you this is a quick way to achieve this.

Thanks, Sachin

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.