connect

Hi everyone, I'd like to know if someone tried to find out any solution, how to connect desktop MS Excel to Snowflake server (as well as we connect to this server via Tableau). Is there any possibility how do that? Thanks, Tomas.

When I pressed new query, from file, from worksheet afterchoosing a file it says unable to connect plz help answer by tomorow

I want to connect to workbooks a hyperlink from one cell to another cell in a different existing workbook

Hello, I am new to web services, and I am trying to connect to DHL timetable WS. https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx The WSDL can be found here: https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx?wsdl When I connect through SoapUI 5.4.0, I can send requests and recieve...

Hi all, I've done a few searches for this, and while others seem to be having the same problem, the causes seem like they might be different. I'm trying to connect to a union query in Access from Excel (both on Office 365 and updated). I built the two different select queries separately as '1'...

HI We are using oracle database 11g. Widows 8.1 64 Bit OS MS office -2013 32 Bit. We want to connect to database and run a query. Can i save the DB connection password without user entering every time when refresh the data. Can you please provide the required steps to achieve this...

Hey guys, I'm trying to filter a report, but I want to filter multiple columns. for example, in column 1 I want to show the values "base" and "connect" and in column 2 I want to show the rows that contain "subgroup". however, the issue is, that rows that have base or connect in the first row...

Hi Team, I want to connect a software using VBA and want to copy the content of the software into excel spreadsheet. how can i do. Please suggest. Regards Rahul Bakshi

Hi I want to connect power query to an excel file that resides on a web page, no login required, here is the web page Unidad de valor real (UVR) | Banco de la Republica (banco central de Colombia) it is posible?

Hi, I have created a pivot line chart which tracks employee daily productivity scores, if there is no value - ie the employee didn't work that day or was not on the rota which would produce a productivity score, then i want the lines to connect to each other rather than dropping to zero. I am...

Hi All, I have reperative code which I am trying to sort but can't seem to crack it. What I am trying to do is put SQL in a sub and then make it connect to a seperate excel sheet. At the minute I have to put the connect code in each module so is in about 5 times. Is there anyway to just have...

Hi There, I am trying to connect to an oracle database with no success... If I use an SQL tool (Rapid) I have to add the server name. port number and Service name. I have Oracle installed on my PC (Oracle Client 11g and Oracle Client ORA Files). I have goggled about and cannot find a piece of...

Hi Guys, I have an equation in A1 whose formula result is a text string for a file destination. In A2 I want to be able to retrieve the value from cell B1 in that file in cell A1. I assume that VBA is required to do this which I dont have a problem using but dont actually know where to start...

I have a workbook in which the user connects to SQL Server Analysis Service Cubes. The server is not a part of an Active Directory domain and thus Windows Authentication is not an option. For security reasons storing the password in the excel file is also not an option. The workbook uses a form...

I purchased PowerPivot For The Data Analyst and downloaded the associated example files. When I try to import the demo file I get the following message: An error occurred while loading the file. More Details:Failed to connect to the server. Reason: No error message available, result code...

Hello All, First, thank you for view my question. I am trying to link data from a website to excel, and have it automatically update, but it doesn't seem to be working. I have excel 2007. 1. I go to the "data tab", 2. click "from web", 3. paste the website I am trying to get data from...

I've tried to use DLookup in Excel, but how do I connect to my database before i use the function? I've tried Private Sub HentData() MsgBox Access.Application.DLookup("[Name]", "Persons", "[Id] = 2") End Sub but i guess it wont work before i choose which database i will use.

Hi all, hope someone can help me! I cannot get a connection to this MySql database for the life of me I have tried everything. this is where im at at the moment http://itc.virginia.edu/desktop/web/mysql/msaccess.html. ip, port and credentials are all good but I keep getting the 'Connection...

Hi there I have an excel sheet which queries a MySQL database. It all runs well (if connected first, which it does when the Workbook is first opened) However I am now trying to detect when there is no connection (for whatever reason) so it reconnects again before running any queries. The...

Hi all Please may you assist with this one I would like to link Sheet 1 to Sheet 2 (Both sheets are in the same workbook) so that sheet 2 displays the selected data of sheet 1 Also I dont want to show all of the data from sheet 1 ie. I only want to show everything in columns A,D, E & J...