Wednesday, February 3, 2021

MS SQL SERVER - How to connect Excel to MS SQL server

 1.  Run \\IP/Ip Name  Set Credential Yes and Set Credential in Windows control Panel

2.  Open Excel go to Data go to File Others Source go to  Select MS SQL Server Set Credential Ok
3. View database which is MS SQl Server

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...