Where to store data for connecting to the database?

A

A

Anton AK2015-08-16 17:13:09

excel

Anton AK, 2015-08-16 17:13:09

Where to store data for connecting to the database?

There are several Excel files that work with MS SQL database through VBA. That is, the connection to MS SQL is present in all Excel files. The question is the following. I want to combine the settings for connecting to the MS SQL database in one place. What is the best way to do this? In this case, the user should not see these settings.

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

N

NKhramenko2021-12-27 15:15:45

Is it possible to make an automated transfer of data from 50 tables to a summary EXCEL? 0Reply

N

Nastushik2020-09-09 21:10:06

How to import tables on each new sheet of an excel book and, when re-importing, if the numbers match, add a line where the numbers match? 0Reply

N

NaksRif2014-04-14 13:31:57

VBS - how to create a script to convert CSV to TXT? 1Reply

E

EVGENIJ NEFEDOV2018-11-01 12:18:35

How to leave only letters and numbers in a column? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question