connection

Hi, I really hope one of you can help em with this. I know it can be done i just dont know hoe. I have a connection that links to an SQL table and data range on that table however i want to be able to enter a data range in a cell or 2 cells and it bring me back that data. Thanks in advance Dan

Hello, I've recently run into an issue where the formulas in my summary tab are being changed when I refresh my data connection. Has anyone seen this before? Or know how to trouble shoot? To give some context there are two formulas below. When I refresh the data connection the $R:$R changes to...

Goodmorning All I have a small dilemma and was looking for ideas on a work around. There is an Excel report that I have built on our shared drive. This report is based on a table created from a power query link into our company database. I have inserted a macro so that when the workbook is...

Hi, I want to query some data in my worksheet using SQL. This may not be a good idea as I recall some problem with memory leaks or similar, but regardless I can't get it working and would like to I'm using ADODB and I have a working connection (to the current workbook) and can get results...

Hi, I am completely stuck on this one, any help will be appreciated. I have a code which is supposed to do inserts/updates in database. I have connected to database using both (one commented out): Sub SQLConnection() Dim oConn As ADODB.Connection Set oConn = New ADODB.Connection...

Hey everyone, Hoping someone on here can help I am using a data connection from an Access Database to populate a number of tables in excel. The connection works great except that whenever the excel spreadsheet is open no one else is able to make changes to the database. People who access the...

Afternoon All Does anyone know if.... an excel formula can traverse a data connection into an access database? The scenario is we want to implement a dashboard, but the only way to implement appears to be by pulling the data records into excel. Was trying to see if there is a way to have the...

Hello all, I have a coding solution that worked successfully for a number of months but then stopped. I'm self-taught / Google/Youtube taught so you may have to dumb it down for me. The code takes a few fields from Excel and writes it to a SharePoint list. The code still works fine for me and...

Hi guys, I have code to read data from about 50 data tables. Code opens connection, creates recordset and then pass it to the array. Next it close connection and then loop through the array. I am wandering now is this would be actually better/faster to loop through the Recordset itself? Or...

Hi, I have a macro that connects to a DB2 database and returns a recordset that I complete subsequent actions with. I have found that longer queries are causing excel to stall - giving me the 'this program is not responding' and forcing me to restart excel. I have played around with the command...

Good morning, I used to enter my SQL by going into Excel --> Data --> Connections and then add new connection. The tab now has a label called "Queries & Connections" and I can't see where I can add new connections, I've clicked on the new label, but there's nowhere I can see to add a new...

I am having an issue creating data connections in Excel 2016 (365 subscription) to a MS SQL View. When I attempt to create the connection it asks to load data. I've looked through the DATA >>GETDATA>>FROM DATABASE>>FROM SQL SERVER DATABASE in the advanced options area but couldn't find anything...

Hi, This is a long shot. I've set up a connection to a website that pulls historical data into a table in my spreadsheet. I've used the URL below to create the connection/query. My question is is there anyway of automatically updating "end=20180115" so each day when I refresh the spreadsheet...

Good day, Is it at all possible to create a connection from another workbook to include images? As data tables work fine, but leave the images behind. Or in some way dynamically add a number of images to a sheet - possibly from a folder. Thanks in advance for any help.

I am using a centralized data base on an FTP server that I need to form a connection to from excel to write, update, and pull data. Thus far I can get this to work when the data base in on my local computer, but once it's on the server I can't open the connection with a macro. The following is...

Excel 2016 - I have an Excel file that imports a table from SQL Server via a connection created with the Data->Get Data->From Database->From Sql Server Database. As part of the Advanced Options while creating that connection I included a SQL query that basically reads: SELECT...

Hi all.. I have an issue as follows:- I created an Excel file which uses 3 ODBC queries to pull data from Sage Accounts. I (perhaps unwisely) set up a new DSN called 'WELTON',to use for this purpose and pointed it at the data folders. However, I am now using the same report for a different...

I am using the following to create a connection to an Access Db file via the Workbook_Open procedure in ThisWorkbookSet cnConnection = CreateObject("ADODB.Connection") strDbName = ThisWorkbook.Path & "\" & strDbFile cnConnection.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strDbName...

I'm using auto refresh connections and want to put the time of the last connections refresh into a cell. Is that possible?