In this post from 2008 I demonstrated how to get data from Excel worksheets using Macro Scheduler’s database functions.
This works fine if Office is already installed on the PC. But what if you want to get data from an Excel sheet and the PC you are running on doesn’t have Office installed?
Well you need the Office Data Connectivity Components which you can download from microsoft.com here:
http://www.microsoft.com/en-us/download/details.aspx?id=23734
This will install the OLEDB/ODBC drivers which DBConnect can then use to make a connection to a workbook. You can then use DBQuery to retrieve data from a sheet as shown previously.
