Overview
how easily Import Excel sheet data into SQL Server as table
use import data wizard
and select excel sheet file (it should be .xls not .xlsx)
it will automatically use first row as column name
and after finish wizard it will automatically create table and data will insert into new table
in this video we will see both append and delete method for importing excel data into Microsoft sql server management studio
That’s all
Note:while importing excel file if you will face this error “culture is not supported”
then go to control panel -~region -~format and change to “English (United States)”
Error:-?
An error occurred during local report processing Culture is not supported Parameter name: culture 3072 (0x0c00) is invalid culture identifier.
Solution:.
Note:while importing excel file if you will face this error “culture is not supported”
then go to control panel -~go to region -~formats tab and change format to “English (United States)”
Error:-?
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
Solution:.
convert excel sheet file into .xls not .xlsx (for more see demo video)
—————————————————————————————————–
thank you for watching
keep subscribe our channel h2zone
(https://www.youtube.com/c/H2ZONE_SP?sub_confirmation=1)
and don’t forget to press on bell icon to get all upcoming videos of our h2zone channel related to computer and technology tricks and solutions
#window #android #iphone #c #games #photoshop #php #python #wordpress #internet #tricks #MSSql_SERVER
Summary
how you can easily Import Excel sheet data and records into SQL Server as new table automatically with SQL Management Studio Import Data Wizard.
