odbc

I am trying to set up an odbc connection between sage 24 and excel and getting an error "Microsoft mashup interface error". The error appears when I try to the macro recorder to select fields to import via excel. Do you have any ideas ? Thank you. kind regards Kapil

Hi been using ODBC SQL queries for 12months plus, not a huge user of VBA. I am wondering when using a parameter query can I create a string for multiple criteria currently I can use a single criteria customer = ? [and link it to a parameter in cell a1] but anyone know a way I can do...

I used to use office 2016 and I could go to existing connections, select a file dsn and connect via ODBC to JDE iseries to run a query. Now on ProPlus, the file dsn no longer work, so I set up all the connections again and they are stored in "PowerBI style" with "Global Permissions" but I...

any experiences configuring ODBC data source links for Power BI or Excel Power Query?

I am working on a simple project, so I thought, to pull data from and ODBC data source into Excel. I have been a programmer for too many years to mention, but new with VBA and Excel. I have this query, and the columns are not in this order SELECT product.num As titem, product.description...

I use an odbc connection to pull SQL tables in excel. I am having difficulty doing VLOOKUPS on these tables with my own created excel data. I can change the format but thats only a temporary solution. Once i refresh that table I get N/A's. Any insight?

Hi - Does anyone have a workaround for executing a VBA generated SQL command via ODBC on a Mac? This works in Windows, but fails on a Mac. stSQL1 is a string variable having the text of the SQL query. The code fails on the With statement: With...

how can do insert query with odbc into excel sheets? I can do select query with odbc with out open the workbook. can do insert and update querys with out record set? like "Insert into [Sheet1$] (id,name) values (1,'John')" sorry for my english.

I have an Excel workbook that is pulling information from a database through ODBC, I want to have user entered columns that will "stay" with the row. Currently refresh will result in misaligned data, I understand why but have yet to get a fix that works. I though I found a solution with the...

[CODE]I have a pre-configured ODBC connection and come up with the Macro below to REFRESH data. It is working fine but if I am using a workstation that is not configured to ODBC I got an error. I need a revision on the code below to trap the error, instead of an error there will be a message...

Hello everyone, I'm having a problem with Excel remembering query passwords and requiring confirmation when a query is refreshed, even though the password is there and the remember password box is indeed ticked. I've recorded a video so you can see what I mean. As you can see, this is a pain...

Okay, so I've been looking into how to set up an ODBC connection via VBA if a user doesn't have it. I have a parameter based query (in MS Access) tied to an Excel command button that needs an ODBC DSN connection however the users who will be running the Excel file do not have the ODBC connection...

Hello, ODBC on Excel files makes it possible to access a WorkSheet as if it was a table in a database. This is done by naming the table with square brackets and a dollar, like this: SELECT customer FROM [Sheet1$] . What I really would like to do is accessing a ListObject as if it was a...

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

Hello All, I need to import a 256 column table using power query [every fortnight through ODBC]. There are at least 150 columns in the table are empty however there is no fixed criteria that which column would be empty. I order to refine the data i need to delete these empty columns. I...

I am creating a dashboard in excel to display the status of many projects managed separately in MS Project. I would like to automatically import column headers and data from MS Project directly into a specified sheet within the dashboard workbook each time it opens. Does anyone have experience...

Hi, i have the below macro which takes a range of cells in a single column and concatenates the values into a single string. The string is then passed via an ODBC connection to SQL to be used as the variables the "Where" statement. My problem seems to be related to how long the string i am...

I have a file that links from Excel Mac 2011 to a local filemaker 12 source via ODBC. The link produces a table in excel of some 7000 rows, 50 columns. This data is then summarized via a pivot tables in the same workbook. The excel file is consistently becoming corrupted. It will work...

Hi, I was just wondering if anyone has successfully connected a Sybase Adaptive Server Anywhere database to Powerpivot? I can use the existing ODBC connection in Excel and this is fine, as soon as I go to Powerpivot, use ODBC, it just errors! Any suggestions?

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