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.