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?
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.
Need to connect excel VBA to snowflake. Can anyone provide a connection string for that?
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.
Hi, I have exported data into excel file using oledb since I cannot use interop or any third party library. Here is my code ''' ''' Export datagridview's data contained in an data table to excel file
I was using the below line for connection in my VBA application in window 8 and excel 2013 but when I tried to use my application from window 10 and Excel 2016, it fails to start with an Error.
I am trying to make a data connection between Excel to csv file but the csv file every date is change.
Using vba and Microsoft.ACE.OLEDB.12.0 connection to Excel 2013 workbook. Inserting records into worksheet work fine. Problem occurs if I update a field in a record with a blank ("").
I need to know how to open a password protected Excel file using OleDBConnection. I saw a post that provides a work around. I am using Excel 2016. Is there a way in this version? The excel is 2013 and older.
Hi, my name is Marvin and I have little experience in Mysql. I have mysql 5.5 installed with workbench 6.1. I work with vba excel developing small applications, locally I have no problems connecting to databases.
Can I use ADO to open a connection to a shared Excel (Office 365) workbook that resides on SharePoint. I do not want to checkout the work book as Other people are storing information on it.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(11.2.0.1) ODBC driver on my Excel.
Hi, I use a OdbcConnection string to read xls sheet into a data table (VB.net) is there a property I can use to omit formulas (ex. Vlookup) and use the values instead?
Hi there: I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user.
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).
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;
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.
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".
Hi All, can anyone provide connectionstring for Excel 2010. I tried to set connection string for RPA Automation anywhere but it is throwing an error
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 :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data
I have a connection string as below. connectString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;ISAM=1;TypeGuessRows=0'";
Hi, I have connected a Excel 2016 file to a SQL Server and it works ok. An user, who has Excel 2007 version should use the same file and he is reporting this error while refreshing the data: Run-time error '1004': Application-defined or object-defined error.
I'm composing a chart from 3 columns of data, and need help to format on Excel for Mac, Office 365. All columns are %s. first is X axis: relative % 0 - 200, of Y and Z.
Hi I am using excel 2010, my excel file connected to dbf file and excel file has my pivot tables based on the dbf file and once the dbf file is updated I refresh the excel file and all the charts are updated.
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")
I have been successfully using the following PostgreSQL connection string in multiple Excel 2010 vba applications running on 64 bit Windows 7 systems. I have moved to a Window 10 system and my application will randomly lose it's connection to the DSN.
Is there a way to use Microsoft.ACE.OLEDB.12.0 in order to connect to a excel xltm (macro enable template)? Thanks