odbc

I have a spreadsheet which includes multipe queries that connect to the same "live" database via an ODBC connection. There are multiple sheets in the workbook; each sheet pulls a different query from the same "live" database using the same ODBC connection. My goal is to allow a user to toggle...

Hoping someone could shed some light on this issue for me - we have a retail management system using SQL and we use Access to run queries. We now use Power Pivot and pull the SQL statements into Excel. But when we use 64bit Office and ODBC, the SQL statements don't run. We have tried it on many...

(Excel 2007) I've been trying to track down the exact way to do this, and I just can't seem to get it. So stop me if I'm doing this all wrong. I have a ODBC data source which consists of a lot of manufacturing BOMs (Bill of Materials), now a customer wants us to make a list of all their boms by...

Hi, I have created a macro which creates a SQL Server connection and returns data as requested - this works fine, however, my macro involves running the same code a number of times - also works fine, just with different connections - still all working! However, because I am making a number of...

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

Hi All, I have data on two sheets of a workbook which are joined by a VLOOKUP. I have the data I want to use in a mail merge on one of the two sheets in this workbook, but, when I create a new data source for my Word Merge using ODBC data sources, the workbook only contains one sheet, and it...

Hey ho I'm trying to move part of an Oracle table-view into a new Access(2010) table. I tried linking the table with an ODBC connection from Access - but the Oracle table is both too large for Access to handle, and Access also ended up jamming the server and p*****g off the Oracle DBAs. I...

I need to know how I can update the SQL Command in an excel spreadsheet that is connected to an Access Query where data is refreshed in order to change the names of the fields that is being pulled from the Access Query to match after they were changed. We recently changed the names of the table...

Hi All, I am trying to change the absolute file path for my connected workbooks to relative, but I'm coming across errors and I'm not too sure how to resolve. My folder structure is as follows: Client (folder) -Master Report.xlsm (file) --Data (folder) ---dataset1.xlsm (file) ---dataset2.xlsm...

We have a VB.Net (201) program that uses Excel (2013) via a ODBC connection string. We have found that we get a value of null (or Nothing in VB) for SOME NUMERIC fields but not all. Changing the Excel cell format does not help. Putting in a single quotes '6000 does work (this makes it a...

Hi, I am a little out of my element with this one: With VBA in Excel 2010 I am connecting to a SQL server by using ODBC. This is a two part process: Part one: I have created a connection string that gets me the following data: A, B, C, D, E from sheet tpoPurchOrder Where B is equal to "1"...

Code works with 32 bit systems, but do not work with 64-bit. what can I do? When i click macro, then displays a message "I can't connect to the server - General ODBC Error"...

I've trawled the depths of Google (beyond page 20 of search results!) to try and find a solution to my current problem. Given that I haven't found a solution I'm tempted to believe that it's impossible but being an eternal optimist I've now decided to post something in here. Outline of what I...

Hi, I just installed WIN7 and OFFICE 2010 and when I run macro I got error like: Run-time error '1004': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. do you know which driver in office is missing ???

If I run this vba it removes the external data connection to the pivot table: ActiveWorkbook.Connections("EXAMPLE").Delete When I attempt to drill down into the pivot table it states the data connection was removed. Is there a way to remove the data connection but preserve the data in the...

Hi there, thanks for looking at my issue. I think it's a simple question but I'm a newbie with regards to ODBC. I have a workbook that has multiple queries, each on it's own tab. When I run the report my macro refreshes all the queries, and it makes the user enter their user name and password...

Hello everyone. This is my first time posting to this site so I apologize for any trouble this may cause in terms of what might be expected and what not. Anyways. I'm currently having a problem where I have both data from an ODBC query and data that was manually put into a table. This works...

Excel 2007 -- Windows 7 I've developed a pretty slick workbook that uses an ODBC connection to connect Excel with my mysql db. In sheet 2, it essentially dumps the data (personal information type data) from the db into a table. Sheet 1 takes that data and in each row lists a few pieces of...

Hi All, I have a current ODBC link created a while back that is querying an Excel file. What I would like to do now is to through each ODBC Connection in the workbook and update the Connection String so it uses a different path where another .xls file of the same name is located. In other...

I have a Microsoft query that I created in Excel 2003, and saved the results as an Excel spreadsheet. The query pulls the data from another spreadsheet. I refresh the results each month by opening the spreadsheet, right-clicking within the results table, and choosing Refresh Data. I recently...