Step by Step to import Data to SQL Server
1. Right Click on the specific database and Choose import from Tasks
2.
3. Select Microsoft Office 12.0 Access Database Engine OLEDB Provider
4. Click Properties and enter Datasource
5. Choose the Destination
6. Then Specify Table Copy or Query and Select the specific tables and views.
7. After you may execute by choosing Execute immediately.
