Wednesday, May 21, 2008

Import SQL table as Sharepoint List

1. Export the SQL table into an excel file.
2. Go to Site Actions > View All Site Content > Create > Import Spreadsheet

3. Give the list a name called Location, browse the excel file to import.

4. Select the Range of Cells range type, click the _ button to select range.

5. Select the data you wanted to import and click the red arrow button.

6. Click the Import button.

7.The Location list is created.
blog comments powered by Disqus