Import Data from SQL Server to Excel | Create a report in seconds
198.5 هزار بار بازدید -
9 سال پیش
-
In this video, I'm going
In this video, I'm going to show you how to import a database from a SQL Server into Excel. This is a great way to get the data out of the database and into a spreadsheet for analysis.
👉 Join now our QnA Community - https://bit.ly/335Fic7
Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager.
Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel.
00:00 Introduction to SQL Server
00:45 How to Import Data from SQL Server to Excel
01:51 Press Excel Shortcuts Alt + F11 (To open a VBA Page)
02:38 How to insert Module in Excel VBA
02:45 How to write code in Excel VBA
07:47 How to run the code in SQL Server
08:14 How to a create button in Excel to get data from SQL Server
10:04 Text Formatting using Excel Macros
Import Data from SQL Server to Excel | Create a report in seconds
#Excel #SQL #ImportData
👉 Check out Excel VBA tutorial Playlist - https://youtube.com/playlist?list=PLnVcHd3TXd2oTUCsERbS9gPlTgpXy7KDL
Let's Connect:
👉 Follow us on Instagram https://www.instagram.com/yodalearning/
👉 Follow our boards at https://in.pinterest.com/yodalearning/pins/
9 سال پیش
در تاریخ 1395/01/17 منتشر شده
است.
198,506
بـار بازدید شده