Thought I would put this up here for future reference. #1 Helped me figure out how to retrieve a region within an excel sheet instead of the whole sheet. I didn’t know you could do things like “SELECT * FROM [Sheet1$A1:B10]” which will only retrieve the values with those rows and columns. You can also retrieve data inside named ranges.

If you want to be able to figure out the name of the first worksheet, then have a look at link #2. You have to get it out of the database schema.

Very useful.

  1. http://support.microsoft.com/kb/257819
  2. http://blog.lab49.com/archives/196