odbc

  1. D

    ROOKIE here with (hopefully) simple request

    First off I apologize for the lack of detail, this is for work so I cant give exact info on variables etc. Also I am new to PowerQuery. I have established my ODBC connection (=Odbc.Query("dsn=private", "Select#(lf)variable1, ...") so: (Select x, y From z Where x in ('')) and I would like to...
  2. J

    How to reresh all ODBC Connection in a workbook, but Connection is an Excel File

    Hello everyone, I'm using the following code to refresh all my ODBC connections. For Each cn In ActiveWorkbook.Connections cn.ODBCConnection.BackgroundQuery = False cn.Refresh Next Recently I added a table of an Excel File as a new Connection. But now the code doesn't work...
  3. U

    ODBC connection issue (from MySQL database)

    Hi guys, I've built a pretty basic database using MySQL Workbench - and I've uploaded a bunch of data. Now I am trying to pull data from my database into MS Excel using an ODBC connection via Excel's Get Data. However, after setting up the ODBC connection, I'm getting the following error for...
  4. M

    How to manage ODBC connections

    Hello everyone, I have an Excel application (like an end user computing app) used by employees to communicate with a remote database through ODBC calls. The ConnectionString use a generic account and a password stored in a third-party file, when users open the Excel tool the connection is...
  5. ScottDarth

    VBA ODBC Activity is crashing Excel

    I'm trying to write some code that will iterate through rows in an Excel spreadsheet (I'm using Excel 365 Version 1908). For each row, it'll check to see if that row's "unique identifier" exists in a database. It *happens* to be a DB2 database, but it could be any ODBC source. I'm trying to...
  6. M

    ODBC Microsoft Access Driver Login Failed

    Hello All, I have an excel workbook which is linked to an Access Query via the Data>Get Data Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me. The past couple of days I have started to receive the following: "ODBC Microsoft Access...
  7. L

    ODBC Connection to Access in 365

    Hi, I have a file in which I created a new ODBC connection to a query in our Access DB in Office 365 by going to Data > Get Data > From Database > From Microsoft Access Database and searched for the query and added it. It works fine and refreshes for me; however, my peer is getting an error...
  8. C

    Large, unstable ODBC file

    HI, How large are ODC files? I have one that is 3mb, even when I reduce it to a few lines. Itis slow and lumbering. Is this normal fo ODBC files? Thanks
  9. D

    Parameter in ODBC PowerQuery

    Hi Everyone, I've tried to use a parameter from Excel cell to modify an ODBC Query from AS400 Database like this: let BUPKTO = Kunde, Quelle = Odbc.Query("dsn=AS400", "SELECT BBU00.BUFNR, BBU00.BUBHKZ, BBU00.BUPKTO, #(lf)FROM WWC400.WEXFILE.BBU00 BBU00#(lf)WHERE (BBU00.BUFNR='01') AND...
  10. L

    Excel VBA connection to MYSQL using Transactions

    I need to write to multiple tables in my MySql database from excel (possibly 20 plus). I will be needing to use PK of certain tables i update as FK of others. I would really like to use Transactions to insure all information is update and if something errors out for any reason then i can...
  11. P

    Found connection problem when run VBA to direct connect Oracle Database

    Hi, Currently, I write VBA script to connect Oracle Database by using ODBC. But I found connection problem until I do steps to success inquiry to get data as followings: 1. Open excel file > Tab "Developer" > Visual Basic > Run button to get data Found error message Run-time error...
  12. 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.
  13. S

    ODBC Microsoft Access Driver Login Failed

    Hi, I have an excel spreadsheet that has a MS query where it pulls data from an Access database query. This has always worked fine up until now. When i attempt to run/refresh the spreadsheet i get the message: ODBC Microsoft Access Driver login failed C:\users\****\desktop\predictor.2015.mdb...
  14. Alex O

    Adding a User Form to ODBC file?

    I’m constructing an inventory file that’s ODBC linked. Said file will be handed off to a clerical assistant when finished. Can a user form be added to edit the query when adding client numbers, or will the user have to edit the actual sql script? If so, are there any tutorials that any of you...
  15. T

    Macro to copy cells due to certain cell value and past to bottom of rows on a new sheet

    Hi, I am having difficulty with a copy and paste macro. I currently have a workbook in which I have a "Master" Sheet and a "ODBC" Sheet. I am wanting a macro to look at cell values on the ODBC sheet in column T and if they read "New Starter" I am wanting it to copy the aligning cells from...
  16. H

    ODBC - SQL Statement help

    Hi all, I am using a SQL statement via ODBC to query a CRM table. I want to group the results by number of appointments in a month by company. So my raw data example is Company Name Appointment Date Appointment Type Joe Bloggs 01/01/2018 Audit Joe Bloggs...
  17. C

    Connect to a database without a driver

    Hello, I have question regarding downloading data from database in MySQL to Excel. For my colleagues I want to make application in Excel that connects to my tables in MySQL and download data. They will need to install my add-in and I do not want to bother them with installation of ODBC driver...
  18. C

    Connect to MySQL without ODBC

    Hello, I have question regarding downloading data from database in MySQL to Excel. For my colleagues I want to make application in Excel that connects to my tables in MySQL and download data. They will need to install my add-in and I do not want to bother them with installation of ODBC driver...
  19. P

    Some columns gets blank in pivot source data

    I have existing excel (ver 2010) with pivot. This excel is refreshed programmatically from c# application. The pivot is created with OBDC with sql stored procedure (which returns the sql table after performing some business logic) to pull the data. When the excel is refreshed programmatically...
  20. C

    excel vba on refresh odbc deadlock victim

    I have an excel file in which I have made three data connections using the data connection wizard. the option first selected was "ODBC DSN". I have unchecked the "refresh every XX minutes" option since sometimes when refreshing I get a popup window with an OK button that states that there was a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top