title: Importing .xls to Access .mdb: External Table is not in the expected format
body: <p>I have a macro that imports a spreadsheet as follows:  (this spreadsheet is an export from a web-based application, and during the initial export the chosen format is 97-2003)</p>
  
  <pre><code>DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "d2s_safety_tbl", _
  "\\company.com\dfsroot$\Share\office_public\D2S\D2S\D2S_Scorecard\Source Data\D2S\D2S Safety.xls", True
  </code></pre>
  
  <p>When importing to Access, I get: </p>
  
  <p><code>Run-time Error '3274': External table is not in the expected format.</code>  </p>
  
  <p>When I open this Excel file, I get a dialog </p>
  
  <p><code>"The file you are trying to open is in a different format than specified by the file extension..."</code></p>
  
  <p>So the file name is .xls, my computer tells me its the 97-2003 Format, but once I open the file and click save, it defaults to save it as a Web Page format with the option to save as .xls.  What gives?</p>
  
  <p>UPDATE: If I open the file, then Save As .xls format (seemingly redundant, but apparently not), it asks me if I want to overwrite the existing file, so I do.  Once I go through this, the VBA import is successful.  I can't have the clerk go through this process every week--any way to avoidd this?  Possibly the initial export from the web-based application?</p>