Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :Stored_Proc_Data.
Server & instance is QGZZZ\MYINSTANCE db is data
The SP has a parameter taken from a cell in the spreadsheet
Here is what I have
oConn.Provider = "sqloledb"
oConn.Open "Data Source=QGZZZ\MYINSTANCE;Database=data;Uid=ABC;Pwd=DEF;"
.CommandText = "EXECUTE PROD.FINANCIAL_STATEMENTS '" & range("Parameters!G5").Value & "'"
Can someone please give me an example
VBA update sharepoint inserts
I think I'm almost there. Except the update is inserting into sharepoint. Using Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0. See code below. Situation: I'm refreshing in an excel table from a power query a Sharepoint list (Sharepoint server 2016).0 votes3 answersThe Dinos2 days ago
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski2 weeks ago
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan1 month ago
Non-Standard Port with SQL Server ODBC
Why does the SQL Server ODBC Connection page not mention any example of using a non-standard port? I was incorrectly trying to use the "Port" attribute as "Port=x" but that does not work.0 votes0 answersDavid Garcia1 month ago
NUODB to SQL database migration
Hi Guys I am using SQL Server 2012 , using import and export wizard i want to migrate nuodb databse to sql , but could not find any JDBC data source inside the wizard.0 votes0 answersGautam Raj1 month ago
Connection string issue in connecting to SQL Server
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."0 votes0 answersFaizan Rahman3 months ago
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".0 votes1 answerlee avery3 months ago
Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database0 votes0 answersAdrian Feldman3 months ago
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !0 votes0 answersFrank Lehmann3 months ago
Hi All, can anyone provide connectionstring for Excel 2010. I tried to set connection string for RPA Automation anywhere but it is throwing an error0 votes1 answerSiva Shanker4 months ago
- Load more posts