There are tons of ways to get the data from Excel worksheet. This one might be not so obvious at the first glance. In this article I’m going to show You how to query Excel data using SQL in VBA.
When it comes to big amount of data, Excel application is not the best solution to work with, in case of storage. Much better fit would be a database like Access or MSSM. In this article I’m going to show You how to connect to Microsoft SQL Server using VBA.