Excel-to-Excel Connection to run SQL queries

[Larry Haydn]

Problem A
=======
I have:
* An Excel VBA application, lets call it A
* An Excel workbook, to act as the database, lets call it B

Is it possible to create an A-to-B connection to run SQL queries, without opening A?

If so, what is the connection string?

Problem B
=======
If the above is not possible, can I open B and run SQL queries from A?
What would be the syntax for the SQL statement?

PS:
I am familiar with connections to SQL Server, but some customers do not have SQL Server installed.
(Cost is the consideration)

 

[Larry Haydn]

Found a good explanation here: