https://kudutek.com/xlnavigator/'>https://kudutek.com/xlnavigator/
Learn how to insert data into SQL table from Excel step by step. In this video I show you how to add and update SQL data from Excel and use Excel to validate data before you insert or update a SQL table from Excel. Although you can use SQL Server to import Excel data as tables into SQL Server, it is not meant to be a userfriendly affordable tool that users can use to review, validate and load data into SQL database. So, the purpose of this video is to show you how to accomplish the latter. I.e. a userfriendly solution to export, validate and import data into a SQL database.
Instead of creating an Excel SQL application based on the AdventureWorks demo database I decided to teach you based on some actual Excel SQL tools that I have created for eautomate. In this video I will provide you with the Excel sample file that I used in this video based on the eautomate customer messages utility that I created several years ago.
I will also provide you a SQL script that contains the two derived eautomate SQL tables and demo data that you can use to install the demo database on your SQL Server and enable you to run the Excel sample files on the same data that I show in the video.
Useful links:
https://kudutek.com/reference/excel/e...
To download the Excel sample and SQL demo data script files showed in this video:
https://kudutek.com/downloads/ExportU...
https://kudutek.com/downloads/CoDemo.zip'>https://kudutek.com/downloads/CoDemo.zip
Watch the first video in this series that teaches you how to Export and Update SQL Server table data using Excel Step by Step:
• How to Export and Update SQL Server t...
And here is the second video that continues where the first video ended. This video shows you how to implement SQL data update functionality using Excel and VBA:
• How to Export and Update SQL Server t...
Subscribe to this channel here and get notified when we publish new videos:
/ @kudutek
To replay this video on how to insert data into SQL table from Excel step by step:
• How to Insert Data into SQL Table fro...
Visit our blog here:
https://kudutek.com
For interest’s sake, eautomate is the leading ERP software used by office equipment dealers and is owned by ECI Software Solutions. Follow the link below to learn more about eautomate and ECI:
https://www.ecisolutions.com/officet...
DISCLAIMER –
KuduTek is not affiliated with ECI Software Solutions, and the custom solutions that KuduTek offers and that I mention in this video are not supported or endorsed by ECI Software Solutions.