connection

I’m hoping someone can help with a problem dealing with data connections. I’m trying to create a tool that will refresh an existing web data connection on the active sheet, prompting the user to input a new URL. This is a generic utility, intended to work on any existing data connection. My plan...

I am trying to find data from access using the below code. The variable R is the date which it will search in the table. If date find in table, it will pickup data from some of the field else it will close the connection and loop will forward. Now the statement "On Error GoTo ST2" is working for...

I have a file with an ODBC connection that works just fine on my windows computer. When my boss insists on using his mac to edit the file, the data connection is disabled. Not only is it disabled, I cannot get the connection back. So my question is...is there a way to prevent a mac from...

Hi, I have two excel files, worksheet1 is linked to worksheet2 via a data connection query to retrieve table information. Everything works fine when the files are in the same location, however when I send the files to someone else on a different server the connection falls over. Other than...

Hi All, The below connection code line using to send data in access DB. cs = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\inmum-i-fs4\group$\WNA Skyline\H&B\Timesheet_Data.accdb" I want to modify this code for older version of access DB. Can anyone please provide me code..

Hi, I have set up a data connection / query to another excel file which is a master list so that when the master list is updated all copies of my other sheet update with the same source data. Both files are located on the same network which all users have write access to. When I refresh the...

Is there a way to get workbook connection properties (i.e. connection string, command text, etc.) from closed workbooks via VBA? Any direction on how to get this information is much appreciated. Thank you.

I have a macro which uses the following connection string below. This works great on our 64bit windows 8.1 which is running 32bit excel and access (our database we connect to). However, we have some new laptops with windows 10 64bit and 32bit excel and access which it creates the 3706 provider...

Hi Trying to use Power Pivot on Power Query connection in Excel 2010. I open workbook connection in Power Query. Hit next. At “Specify a SQL Query if I do “Design” and “Table import wizard”/text and select “run” all data seems to be displayed. However when I click “OK” and “finish” after the...

Hi guys, I've downloaded an XLS file with a pivot table. The source data for this pivot table is an OLE DB connection but I don't have the credentials for this connection. The file is quite large so I assume all the data are already in my file. Is there any way (Excepting double click in my...

Hello Guys Has anybody found a way to connect directly to Magento databases to extract data on a read-only connection basis? I have seen some $600 rip off pieces of software but I am sure there must be a direct connection excel can connect. I have searched on here and Google with no luck.

Hello, I am fairly new to Oracle Smart View and have been recently assigned to debug an issue with establishing a connection to our National Sales connection. Establishing a connection requires logging in with a username and password. How do I properly establish a connection to National...

Hey there…I have a slicer linked to multiple pivots whose data connection is an olap cube. My goal is to change the olap cube connection and then change the data sources for all pivots and still attempting to keep the slicer in tack. Here was my approach: Add the new olap cube connection to...

I've looked for three days and tried several solutions that were close but I'm still at zero progress. REQUEST: I exported the ODC Connection Files that point to my Dev and Prod SharePoint sites and uploaded the files to a SupportFiles Document Library the Workbook has access to. Right now, I...

Hi I have an excel file with various power query that are loaded to the data model as connection only. I've tried to save the file with a different name as a backup but now the queries don't work - they say no connection exists Is this a bug or do I need to reconnect the queries somehow - if...

Dear Experts, we are facing in our organization an audit issue with excel as most of our reports are connected directly to SQL server. the risk that has been raised by audit is that in the connection string and the user name and password are visible. we are following this method for our...

Hi All I have a report set up with around 100 pivot tables set up connected to a SQL Express Connection. I have been given a new PC at work so I have a new instance of SQL Ex. I have 'restored' my old tables onto my new machine and now I need to point my pivot tables at the new version. My...

I have an issue that only started after an upgrade to Office 365 ProPlus 1708.8431.2215 If I create a PowerQuery using Connection Only, when I reference the connection later via a new pivot table [ Insert ... Pivot Table ... Use an External Data Source ... Choose Connection .... Query A ] then...

I have about 30 connections connected to different excel sheets within 1 workbook. I want to know how to get the command text for each connection using VBA code. This is what I have thus far: Function Connections() Dim conn As WorkbookConnection Dim celltxt As String For Each conn In...

Hello, i have a workbook, that i want to share, currently it has two tables within it. The tables are refreshed through VBA from a sharepoint connection. I am aware how to convert the Tables to Ranges which will allow me to Share, but this removes the connection I have. Is there away of...