connection

Hi all, I am a frequent Excel user and want to learn about Power Pivot, as I will have to handle very large datasets. So I began to read tutorials and saw that SQL is very often a source of data. I installed SQL server 2012 on my laptop and wanted to begin working with...

Seems simple, but I'm going crazy trying to figure this out. If I have a text data connection set up to pull in data from a closed CSV on my desktop, and I set it up to drop the data (when I refresh the connection) in cell A1 of Sheet1, how/where can I CHANGE that to a different location? e.g...

Hello, What I'm looking for is a way to suppress the Analysis Services Connection wizard from popping up if a user inputs an incorrect variable for a OLEDB connection. Basically I have 3 variables. Server, cube and user. I build the connection and then prior to using it, I test it by using...

Thanks in advance for anyone who reads this and takes the time to respond. First, I will preface that I am new to VBA and I didn't create the code I am trying to change. With that being said... We have some spreadsheets that use VBA to create a connection string which is used to connect to a...

Hello everyone: I'm trying to delete all records in a RecordSet ADODB Object connected to a Excel Sheet, using two differents ways: Delete records using an ADODB Connection Object Delete records using an ADODB RecordSet Object Also, as far as I know MS recommend to use the 2nd So, what...

Currently I've got a n Excel workbook with 3 external data sources. 2 of those sources are data dumps from SAP/BOBJ and I don't have an issue. The 3rd data connection is another Excel file used my multiple other users. The 3rd file is the issue, if someone has it open when the data connection...

I think I came across a cool workaround for gluing connectionlines to the corners of a rectangle. The normal connection points are in thecenter of each side. I wanted connection points at the corners. Using Insert Shape, I drew a large rectangle whilezoomed out to ~10%. I then zoomed into the...

Hi all, I have used power query to established a connection to a an access database file with almost 3 million rows. However, I am trying to edit the Command Text properties under the definition tab. Currently the connection string is Provider=Microsoft.Mashup.OleDb.1;Data...

Before I get into the issue I am experiencing, I think it should be said that my expertise in this matter is extremely lacking, so pretend that we're on /r/explainitlikeim5. I'll also note that I have tried to do some extensive research across multiple sites and forums, but nothing that really...

I'm analysing a bulk set of files and want to log details of each one, including any Query and Connection information. I'm struggling to extract the Connection String Within my code loops I have the following so far Debug.Print "_______________________" & vbLf & "Queries and Connections:" For...

I have used Power Query to create a Connection only Query from an Excel Table. Now I want to create a query based on the Connection Only Query and send the result to an Excel Table on a Spreadsheet. How do I do that? Excel Table: Transactions Power Query from Transactions: qTransactions Power...

Hi I’m working on importing a table from a web however the issue I am having is that the table is divided into pages based on the number of records . I need my my excel workbook to be able to import all the records into the workbook regardless of the fact they are dividing up into pages with...

I have no prior experience with SQL databases, so this is my first try. Please bear with me... My database is a regular *.sqlite file which I'd like to connect to Excel through ADO interface using VBA. The connection string (ConnectionString) below is taken from...

Guys I'm a newbie with OOP (Object-oriented programming) I need your assistance to develop a connection inside a class so I can get/access this connection on a module. Here below the function the connects to the SQL Server that is working fine. What I need is make reference to this function...

Having used this forum many times over the years for tips I find myself posting for the first time with a query, so here goes I am using data connection to retrieve data from dozens of workbooks, each workbook has 17 worksheets, Apr through Dec, total of Q1, Q2, Q3, Q4 and Grand Total To...

Hi, I have a workbook with a connection to a cube in an SQL Analysis Server (a .odc file). I have created a pivot table based on this connection. I have created another query in Power Query (a select * from a table in a SQL Server) and I want to relate this query to the cube and embed it to...

Hi Team, Is there a way to transfer data from one excel file to other closed excel file. Like we do from excel to access without opening access file/database by creating connection. I tried to create connection between two excel file. Its working fine for extracting data without opening main...

I am trying to close connection but getting error that data is being refreshed in background

I have a data connection that pulls production data into an excel sheet and then I use that data to create an hourly production board. My IT department is URGING me to reduce the size of the connection. In an effort to do so, my thought is to pull less lines of data with each refresh, but I...

Hi can you help on how to create connection between excel file and access database both saved in sharepoint. i have code to connect them on shared drive but not able to do so in sharepoint. Appreciate your help ) Vineet