Ok guys,
You have provided great samples of how you can extract data from a closed file. Now what do we do once we have that data?
Is it possible to create a mini-app that can be run from the desktop that uses SQL to extract data from an Excel file.
Take a phone list for example. For security purposes, we're not supposed to have any personal info accessible from our desks. So I would like to make it easy for my coworkers to have a phone list in the taskbar. It would act like a pop-up and have search and filter functionality. Is this asking too much of SQL?
This is getting exciting!