0
How to Import Excel into MS SQL database table.
I was asked to import the data from the Excel to MSSQL database. I wasn't aware of how to do that. However i found the way to do that. I hope this would help some one.
So Steps,
1. Save the sheet/file as .csv, (Save the file with the same name of the data table would make your life easy )
2. Make sure the column name matches with the data base column names.
3. Right click on the data base and select task and import
4. Choose a Data Source -- Choose the Flat File as Type and Particular File,
5. Choose a Destination -- Choose the Destination as SQL Native Client,
6. Select the data base and Authentication
7. Make sure all the columns are mapped correctly,
8. Finish and see are there any errors, (keep in mind there can be data loses, so make sure the whole process fails or success on such occasion by setting the right fails)
Key Points to note
So Steps,
1. Save the sheet/file as .csv, (Save the file with the same name of the data table would make your life easy )
2. Make sure the column name matches with the data base column names.
3. Right click on the data base and select task and import
4. Choose a Data Source -- Choose the Flat File as Type and Particular File,
5. Choose a Destination -- Choose the Destination as SQL Native Client,
6. Select the data base and Authentication
7. Make sure all the columns are mapped correctly,
8. Finish and see are there any errors, (keep in mind there can be data loses, so make sure the whole process fails or success on such occasion by setting the right fails)
Key Points to note
- Make sure there are no data could loss
- Make sure the right local
- Make sure the right column mapping
Post a Comment