data connection sql

Morning all, I have a question regarding SQL queries when creating a data connection. I have created a data connection to an external workbook to a sheet that has a table in it. This table starts at row 13 (the headers) and is a dynamic table that gets updated from time to time. In my query...

Hello, I'm just entering the world of connecting to SQL via Excel, so please bear with me if I don't get any of this terminology right. I'm trying to merge live sales data that I import from SQL with static cost values that I track within the same workbook. In my previous iteration of this...

I have a data connection in my workbook that returns customer data. The connection executes a stored procedure on SQL Server that accepts four parameters. The fourth is a true/false value that I have populated using a checkbox tied to a cell listing the checkbox value. That cell is listed as...

Good evening, I am using excel 2010 and I have created a data connection to a SQL server. The query returns all data from a given date to the prior day, however, I envisage that the data set will grow quite large and that the data will start to to take longer to put into excel. I have been...

Hi all, I'm trying to build a workbook (2007) with multiple worksheets where each worksheet corresponds to a different query/dataset pulling data from the one database. I would have expected that you could define the one data connection object and then specify the SQL that each worksheet table...