SQL & Excel 2010

Question

Good morning,

Does anyone know if there is an easy way I can use a SQL query in Excel to select specific data from an Excel spreadsheet without having to use VBA, Access, an SQL database or complicated Excel formula?

Thank you very much.

Answer 1

Hello,

From a program you can use Jet SQL to query an Excel file.

From within Excel, I don't think you can use Jet SQL.

Answer 2

Use Microsoft Query.

I don't have Excel 2010 at the mo. In Excel 2007:

Ribbon: Data, From Other Sources (Get External Data From Other Sources), From Microsoft Query, Choose Data Source (dialog), Databases (tab), Excel File* (listbox), Select Workbook (dialog), browse for file, step through Query Wizard (dialog), at finish choose, View or edit query in Microsoft Query, click SQL (toolbar button) and there you can edit the query or change it entirely.