Ask Your Question

What is the method for linking VBScript (Excel) with a SQL Server web database (using an IP address)?

asked 2022-09-05 11:00:00 +0000

lalupa gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2021-05-03 19:00:00 +0000

devzero gravatar image

There are several methods to link VBScript (Excel) with a SQL Server web database using an IP address. Here is one approach:

  1. Install the SQL Server ODBC driver on the client machine where Excel is installed.
  2. Open Excel and navigate to the Data tab. Click on the From Other Sources dropdown and select From Microsoft Query.
  3. Select the SQL Server ODBC driver as the data source and enter the IP address of the SQL Server in the Server field. Enter the username and password credentials for accessing the database.
  4. Select the database and tables you want to link to Excel and configure any filtering or sorting options as needed.
  5. Once the data is imported into Excel, you can use VBScript to manipulate and analyze the data as needed, using SQL queries and standard Excel functions.

Note that this method assumes that you have the necessary permissions and network access to connect to the SQL Server web database from your client machine. If you encounter any issues, consult with your IT team or database administrator for assistance.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2022-09-05 11:00:00 +0000

Seen: 13 times

Last updated: May 03 '21