Skip to content

Home

Jump to bottom
KohrAhr edited this page Sep 12, 2019 · 8 revisions

Welcome to the SqlOverExcel wiki!

Purpose:

  • run SQL query (MS Access compatible) over MS Excel file

Allowed file types:

  • XLSX -- Excel Workbook (Office 2010..Office 2016)
  • XLSM -- Excel Macro-Enabled Workbook
  • XLSB -- Excel Binary Workbook
  • XLS -- Excel 97-2003 Workbook

Requirements:

  1. .Net framework 4.5.2
  2. Microsoft ACE.OLEDB provider, version 12.0...16.0 is required.

Download Microsoft Access Database Engine 2010 Redistributable from https://www.microsoft.com/en-us/download/details.aspx?id=13255

Download Microsoft Access Database Engine 2016 Redistributable from https://www.microsoft.com/en-us/download/details.aspx?id=54920

Sample

SQL Over Excel

C:\Temp\Excel>SqlOverExcel.exe -in="C:\Temp\Excel\TwoWorksheets.xlsx" -query="SELECT [Table1$].[ID], [Table2$].[ValueAddon], [Table1$].[TextValue] FROM [Table1$] LEFT JOIN [Table2$] ON [Table1$].[IKeyID] = [Table2$].[ID]" -acever=12.0

SQL Query execution running at: 6:22:21 PM

|

SQL Query execution completed at: 6:22:21 PM

12 Super 1 Test 100

14 Super 2 Test 200

Press any key for continue...

Clone this wiki locally