Ejecutar consulta SQL desde Excel EXCELeINFO

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=fk5aHnWTRiU

✅ Download the file | http://www.exceleinfo.com/ejecutar-co... • 🏆 Subscribe | https://goo.gl/M5zNA8 • In this tutorial I am going to show you a simple way to execute a Query or an SQL Query from Excel and to dump the data into a Table. • To develop the tutorial I had to install a virtual machine with Windows Server and SQL Server, to simulate a real environment. Previously I had already developed a tutorial on how to query SQL information using Power Query. In this tutorial we will make a connection equal, but we will use another tool. • Access credentials to the SQL Server • To be able to connect to the SQL Server we must first know the name of the Server or its IP. Inside the virtual machine we execute the CMD application and execute the IPCONFIG command, which will tell us the IP of the Windows Server. The SQL user and password will be the same as those assigned at the time of installation or a user that can be created after the installation. In case you do not have a testing environment like the previous one, I suggest you ask your Systems department for the following information: • -IP or name of the Server. • -Assigned user of SQL. • -Password of the assigned user. • More examples | http://www.exceleinfo.com • More examples | http://blogs.itpro.es/exceleinfo • Facebook Page | / exceleinfo • Get notificacions on Telegram | https://t.me/EXCELeINFO • Twitter | @EXCELeINFO • Twitter | @SergioACamposH • Download EXCELeINFO addin: • http://addin.exceleinfo.com

#############################

New on site