odbc connection

  1. S

    Need Help on ODBC Connection

    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...
  2. P

    Exporting data from Excel to Oracle DB

    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...
  3. A

    Display live(ish) excel data in webpage

    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...
  4. j3andc

    Conditional formatting in ODBC query

    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.
  5. D

    Excel AS400 ODBC Parameter - Comma Separated List

    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...
  6. D

    VBA so cell range is criteria for odbc sql

    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...
  7. V

    Distinct Count using ODBC pivot on PostgreSQL

    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...
  8. 9tanstaafl9

    Need help fixing macro that changed ODBC connection string - was VisualFoxPro now SQL

    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...
  9. J

    Question You are subscribed to this thread Applies to Office Office 2016 Microsoft Office Excel Office for Windows 10 Desktop 4 views SQL Server odbc

    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...
  10. E

    sql to excel to access database

    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...
  11. 9tanstaafl9

    Use VBA to update ODBC path of Visual FoxPro query table connection

    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...
  12. J

    Update Connection String's IP address with cell content change

    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...
  13. P

    Sumifs behaving oddly in Excel 2013

    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...
  14. A

    Using VBA to Call WinSQL - Can it be Done?

    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...
  15. M

    Which occurs first: Code in Workbook_Open procedure, or an ODBC connection set to refresh on open?

    (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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top