excel_sql-server Questionssubmit your own question

I've lost my bold key on spread sheet. How do I get it back? thank you

Hello, i'm working on a portable app with Excel VBA and sqlite, i would like to specify a personal path for dlls in the connection String. can you help me with that ' Chemins personnalisés vers les DLLs et Base de données

Buenas tardes Desde EXCEL VBA Necesito conectarme a dos listas de sharepoint on line para realizar una consulta SQL a las dos listas utilizando JOIN, pero me da error porque no reconoce los nombres dos listas.

How to connect multiple database using sql server

Hi am currently wrtting a vba subroutine that i want to use in order to query a datatable in a worksheet, and then load the recordset into a different datatable in my current worksheet.

exe.config, exe,database available after instal ssms in other pc unable to connect to database from exe to database, exe opening, database opening in sql server, but in exe login form user not showing , means data not showing, kindly help to connect it

How to enable Column always encrypted to SQL server via OLEDB provider

Do you have an entry for Azure SQL Server Managed Instance? I see for Azure SQL. but Azure SQL Managed instance can hold multiple databases

Connection String for Excel 2016 32 bit. The script work without a problem on Office365 Excel version, When the same file is sent to a different user with excel 2016. It get Connection initiation error. "An Error occurred after the connection was established" .

Hello everyone; I need you kind help to solve the following connectionString Data Source=11.111.111.11,1433;(localdb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mydbase.mdf;Initial Catalog=mydbase;User Id=Ibrahim;Password=?????????

Hello, I wonder if you can give me some direction. I have a SQL site developed for data forms inputs by my brother-in-law, a password was given to me to do misc. admin stuff like adding users and data inputs.

I need a connection string to connect to an Excel workbook that is stored ona corporate sharepoint site. I get a "Failure creating file" exception. Here is what I have been using:

Using connection string "Provider=OraOLEDB.Oracle; ....", my VBA code is connected to Oracle 19c. Next, how do I call an Oracle stored procedure of having input parameters and IN/OUT Ref cursor from an Excel VBA script?

I have an application provided by a 3rd party. I can no longer get support for the application. It uses an OLEDB connection to my own database to import information. A security patch is now blocking the use of the OLEDB connection.

I have an application supplied by an outside party who will no longer provide support. The application relies on configuration files to drive most of its operation. One such configuration file depicts a connection to a database.

Hello, I am getting started with MySQL, which I want to drive via vba code in Excel 365 (Office v 32-Bit), on a Windows 10 (64-Bit) PC. I am 'Administrator'. My steps: Downloaded MySQL Server 8.0.32 from Community Downloads.

With a recent upgrade of our PCs to Windows 10 (64 bit) and using iAccess Client Solutions, 32 bit, (iACS), we lost the ability to run Excel VBA automated sessions on our AS400.

We are trying to Connect to Sage 300 CRE. The Timberline Driver ODBC has been installed. When we try to execute an SQL statement: SELECT a.* FROM OPENROWSET('MSDASQL','Driver=Timberline Data;

I want to connect to ABSS software and easily extract accounts, inventories etc. Can I use a similar way like SQL Server connection and do it? What could be the code for ABSS?

Need to connect excel VBA to snowflake. Can anyone provide a connection string for that?

Upgraded from access adp to access 2013 accdb linked tables. Successfully linked the tables to sql server 2019 using SQL Server Driver 17. The database uses a module and lots of stored procedures in the Moduled, forms and reports.

Hello, I would need help on how to create a connection between R and Microsoft Excel. Thank You.

I am trying to connect to a MYSQL database through VBA in Excel. I have been doing so with an administrator account without issue for some time. For security reasons, I wanted to do so with a MYSQL account with lesser permissions.

Hello. I am writing to thank you for your many help. especially those on connection strings which helped me a lot and I thank you for that. Please also help me please. here is my problem:

Bonjour. Je vous écris pour vous remerciez pour vos multiples aides. particulièrement ceux sur des chaînes de connexion qui m'ont beaucoup aidée et je vous en remercie. Je vous prie également de me venir en aide s'il vous plaît.

Hi I am trying to connect to a Oracle Database from SSIS using kerberos /keytab authentication. What will be the connection string for database in case i want to read the pwd from my keytab file

What is meant by changing Namespace and how do you do it, for the new Microsoft.Data.SqlClient

hello. i'm trying to use tables from ms access and explore the data in excel so i want to write a code in vba excel that enables me to connect to the database in access. i searched and i found that i have to use connexion strings..

Hi. I am looking for the right connection string to retrieve data from microsoft sql database (2019 version) to an excel worksheet, using vba. I am currently using the MS Office 2016 version..

I am unable to connect SQL Server database from my Julia Language code web server; I suspect I am not able to figure out proper connection string.