How to Automate an Excel Report with SQL

If you have an Excel file that gets data from a database or CSV file, you can automate this process using a few handy features of SQL Server.

In this video, I'll show you how to import a CSV into an SQL Server database, connect an Excel spreadsheet to the database, and automate this when an update to the CSV file happens.

⏱ TIMESTAMPS:
00:00 - Our CSV
00:35 - Import data
01:41 - Create spreadsheet
03:36 - Create a procedure
04:24 - Change the CSV
05:14 - Automate the step

🔗 VIDEO LINKS:

[mrbartuss]

7:45 Well, actually semi-automatically. You still need to manually trigger the refresh in Excel

[yacinebenjedidia]

Could you please work on some data warehouse projects?

[luckymolefe]

After creating the job it brings back a blank table

[alexmeyburgh]

This probably would not scale we would it? If sales were 100s of thousands of rows per day