Data interchange for SQL Server and Excel import and export

Now, I'll export from SQL Server Datasheet to Excel and then export from Excel Datasheet to SQL Server :

One. SQL Server data tables are exported to Excel:

1. Create a new Excel and select the Data menu:

2. Select Import External Data-after import data:

3. Double-click "New SQL Server connection. ODC":

4. Click "Next":

5. Click "Next":

6. Click "Finish"

7. Click "OK" to import the following data:

Two.Excel Data tables are exported to SQL Server :

1. Right-click database name:

2. Select " Tasks"--"Import data":

3. Click "Next":

4. Click "Next":

5. Click "Next":

6. Click "Next":

7. Click "Next":

8. Click "Finish":

9. Complete: