Read/write Excel data tables (same file or different files) as SQL commands?

Question

Can I create data tables in Excel files that in another Excel file I can read them with SQL commands and the output be exported as another table in an Excel current/external file?

Answer 1

I used another method since.

I simply read the excel file sheet one row at a time and store those row into another workbook. I then process from that other workbook.

My question can be cancelled but I do not know how.

Answer 2

Edited content

Whomever will use my Excel Workbook containing the Data Connection tables to not use MS Access software, only use this Workbook Excel.

Question-1: how do I refer to this loaded table as SQL?

Question-2: is this loaded table a copy of the resulting data or links to the original Workbook where they come from?

Answer 3

Can I create data tables in Excel files that in another Excel file I can read them with SQL commands and the output be exported as another table in an Excel current/external file?

You could export the data to ACCESS do the SQL manipulation there and then re-export the manipulated data back to EXCEL: all of this is very simple and quick to achieve.