title: Error using TransferSpreadsheet to import an Excel spreadsheet
body: <p>I have a routine that helps me locate a the row of word in a standardized worksheet.
  Based on the location of the word - for example, I search in column 'A'
  It finds the word on row 7.</p>
  
  <p>I now know that I can use the range A8:M14 as the data I want to import into my table,  so I created a function 'GETBASELINE' that would just return that string - "A8:M14"</p>
  
  <p>So now I have a table called tbl_TEMP_Import with these fields</p>
  
  <p>BASELINE|OCT|NOV|DEC|JAN|FEB|MAR|APR|MAY|JUN|JUL|AUG|SEP</p>
  
  <p>I call it like so:</p>
  
  <pre><code>DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_TEMP_Import", strPath, False, GetBASELINE(strPath, strSheet)
  </code></pre>
  
  <p>I get Error 2391 Field 'F1' doesn't exist in destination tbl_TEMP_Import</p>
  
  <p>If I change it to 'True' for 'has field names'
  I get Error 3270 'Property Not Found'</p>
  
  <p>I wish I could get better debugging.  Doesn't seem too complex to accomplish this.</p>