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 …

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, …

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 …

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 …

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 …

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 …

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 …

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 …