title: VBA tool to determine SpreadsheetType from given spreadsheet
body: <p>I wish to use the <code>TransferSpreadsheet</code> command to link or import a spreadsheet to Access 2010.
  It requires a value for <code>SpreadsheetType</code> (drawn from the <code>AcSpreadSheetType</code> enumeration).
  What is the Access VBA tool to determine SpreadsheetType from given spreadsheet filename?
  Maybe the only means is to examine the file extension and do a lookup?
  If you've solved this problem before, please share.</p>