Import Data from SQL Server to Excel | Create a report in seconds

Yoda Learning Academy
Yoda Learning Academy
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 بـار بازدید شده
... بیشتر