In the previous post, we seen how to Importing SQL Server table data into the excel.
https://bageshkumarbagi-msbi.blogspot.com/2021/03/importing-sql-server-table-data-to-excel.html
Right-click on the database àselect
tasksà
Export Data
Select the server name and the database name
Click on the next
Selecting
the Destination as Microsoft Access and providing the File name where we are
going to store the data.
In the advance
table, we can set the initial catalog.
After that
we can click on the test connection. If everything is good then we will get the
message like Test Connection Succeeded else we get an error.
Click next
If we want to export more than one table or whole table data in this case we will select option one. If we want to select specific data then we need to write the SQL script to pull the data, in this case, we will select the 2nd option.
Here we are selecting the table name which we want to export.
If we want
to make any change in the data type or table structure in this case we can
click on the Edit Mapping button. After
making changes click on the Ok button.
Click the next
button and review the source and destination.
Click next
Click next.
Click finish
Data copied
successfully.
Now close
the wizard.
Data copied
successfully.
