Day12: Importing Data From Excel File Into Existing Tables in SQL Server

preview_player
Показать описание

This course will help you to understand the basic concept and how to work with the SQL by example.
Рекомендации по теме
Комментарии
Автор

Actually, if your sheet name and data table name are matching, all columns will be mapping instantly, no need to import sheet as new data table.
Btw, tiếng Anh của anh rất ổn. Thanks anh đã làm video chia sẻ!

ogiaang
Автор

It was somewhat informative, but I would have hoped that the category for the added rows would have been more sequential (4, 5, 6) instead of (7, 8, 9)

cjones
Автор

YAH MAN I HAVE DONE WITH WHAT YOU SAID IS PERFECT.

madelinek
Автор

what if there are many columns ? like 20-30 then how to do it ?

akshaygangwani
Автор

thanks for your video. What will happen to the formulas that are the excel table after importing to SQL?

amintaleghani
Автор

i had the Table 2017 with columns such as jan/2017; feb/2017. so can you help me the way to import data 2018 with columns such as jan/2018; feb/2018 into Table 2017? Many thank

trangle