For what I'm trying to do, the SQL query SELECT lastname, firstname, phonenumber WHERE phonenumber IS NOT NULL ORDER BY lastname would do the trick. It seems too simple for it to be …

I am fairly new to SQL and VBA. I have written a SQL query that I would like to be able to call and run from a VBA sub in an excel workbook and then bring the query results into the workbook.

I have data in an Excel file - actually XLSX format since it is now 2020. My requirement is to get this data into SQL Server as follows: ad hoc, the use case being feeding tables with test data, or infrequent …

Nov 4, 2013 · I am trying to make an excel macro that will give me the following function in Excel: =SQL("SELECT heading_1 FROM Table1 WHERE heading_2='foo'") Allowing me to search (and …

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool? Thanks in advance.

How can i export my data from SQL server 2008 into Excel 2010 or later ? i have tried on SQL way: sp_configure 'show advanced options', 0; GO RECONFIGURE; GO sp_configure 'Ad Hoc Distributed …

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\template.xls;', 'SELECT * FROM [SheetName$]') select * from myTable Is there any standard way to use this template …

6 I am trying to embed credentials into an Excel 2016 workbook for an account on my SQL Server 2008R2 database that has execute permissions on certain stored procedures to provide end users …

After I click OK a SQL Server Login dialog box pops up with "Use Trusted Connection" pre-checked. Each time I create a new data connection in Excel (I do this dozens of times per project), I have to …

For this particular lookup - Yes. Most of my vlookups work perfectly well in Excel but the postcodes tables for the product has up-to and over 1 million rows and we have multiple insurers too so I'm just …