odbc connection

Hello. I am using the latest driver (Simba Spark ODBC) to connect to several vNext tables. The connection was working fine until ..approx a week ago. Nothing has changed on the PC as well as on the system data / table side. I am receiving a Reserve Error - 7711. I have tried to refresh / relink...

Hello Everyone, I have connected Excel with a third party accounting software called Tally through ODBC connection. I use the connection to import data in Excel from Tally. Is it possible to send data from excel to Tally through ODBC connection. Usually i do this process manually. First i save...

Hi, I am trying to export data from excel sheet to a table on a oracle database but couldn't get the code below to work It keeps throwing error at 2nd strSQL line. I seek help from forum to get this to work. thanks. Sub ExportXLtoOracle() Dim con As ADODB.Connection Dim conStr As String Dim...

Hi I have created some reports in excel and have various pivots and graphs that I can view/refresh. What I would ultimately like to do is have the contents of the excel page displayed via a web browser so this can be seen by people across the business with out them using the excel spreadsheet...

I have a ODBC query where I want to highlight certain rows when a cell contains the number 1. This last cell is outside of the ODBC query. So far I cannot get the whole row to highlight only one cell. Any help would be greatly appreciated. Thanks Jim S.

I am connected to an AS400 database using Microsoft Query iSeries ODBC. I want to use a parameter and allow the user to put in a list. i.e. where x.Store NOT IN (003,006,008) I tried entering a parameter (?) here, and referencing a cell, but I keep getting a length error. How do I allow the...

Hi I am trying to run an extract based on a range of products within excel. I have used an odbc link but criteria remains static, looking all options up I need to write VBA to create a string based on the range and combine it to the sql my vba is limited to autofilters, pdfs and sorting this...

Hi, I'm trying to perform a distinct count of an attribute of my data. I'm using a pivot table as a view on a PostgreSQL server with data in star schema. In 100% excel (where the data is in the same file) I can simply apply a pivot table and select the option to "add this data to the Data...

My reports used to connect to our database using a VisualFoxPro ODBC driver, but the new version of the database requires an SQL connection. I have been able to connect just fine, my problem is that I need to modify the macro that lets me change the database path when the report is given to...

There are several ways to set up ODBC drivers to SQL Server in Excel 2016. There is one method that is cross-platform Mac/PC but this method is not working for me. One way that does work is from the Data tab of the Ribbon choose Connections. I can set up a connection to my SQL Server that works...

I am bringing in an odbc connection to excel. I brought the table into excel without problem, but if a file gets changed in the database will it reflect in excel? And if I move the excel sheet over to an access database will that also see any changes made? I am using office 2013. Thanks...

Many years ago, I found this wonderful code on mrexcel.com that let me update all the query tables just by changing the connection string. A few Excel versions later, my code is no longer working for all the queries. It works with all the tables created in older versions of Excel, but not the...

I've got a spreadsheet consisting of several ODBC queries that I need to distribute to multiple individuals. The ODBC server's IP address in the Connection String will be different for each individual so I'm looking for a way to update the server's IP address based off of an IP address I enter...

So, I have a spreadsheet that I am using to summarize and trend a bunch of data. My system looks as such: Windows 7 Enterprise 64-bit with SP 1 Intel i7 quad core 2.2GHz 8GB RAM MS Excel 2013 Professional Plus 32-bit edition In this spreadsheet I have multiple worksheets to separate my...

Hello all, I'm a bit of a novice when it comes to VBA; I can write some basic code well enough, but I have been unable to find the information I need for the following situation using Microsoft Excel 2007. In a previous job, I know our actuaries had some VBA code that had some SAS references...

(Using Windows 7, Excel 2010) I have a workbook that has 6 ODBC connections to refresh data tables on open (Background Refresh). I also have code in a "Workbook_Open" procedure that I need to process AFTER the data tables refresh. So here's the question(s): Does the ODBC Refresh happen first...