title: Import Dynamic and Static ranges from Excel in to MS-Access that do not start at cell A1
body: <p>How might I link a data range from an Excel spreadsheet so that the data in that range appears as a useable table in Access?</p>
  
  <p>Linking to an Excel sheet that has data starting at cell A1 is easy enough, but where data in the Excel spreadsheet starts elsewhere in the sheet, I'm not sure how to get Access to pin-point it, especially if that non-A1 range is dynamic.</p>
  
  <p>Access doesn't seem to pick up named/dynamic ranges when going through the import/link wizard.</p>
  
  <p>Real world scenario:</p>
  
  <p>I have an Excel spreadsheet file, let's call it "<strong>ExcelFile1.xls</strong>", that is provided to me externally (so I can't really change its formatting).</p>
  
  <p>1 of the sheets/tabs, let's call it "<em>Dynamic</em>", has a data range I want available as a table in Access, but its column headings start at row 14, going across to column EL. What I'd like Access to do is pick up this data range as a table. Furthermore, "<strong>ExcelFile1.xls</strong>" will also get updated periodically, i.e. a new version of the "ExcelFile.xls" file will become available, but with more data below row 14's column headings, so ideally I would like Access to pick up the new data in this range whenever I overwrite the previous version of "<strong>ExcelFile1.xls</strong>".</p>
  
  <p>I also have another Excel spreadsheet file, let's call it "<strong>ExcelFile2.xls</strong>", again provided to me externally.</p>
  
  <p>This has a sheet/tab, let's call it "<em>Static</em>", that similarly has a data range I want as a table in Access, and again, there will be newer versions of "<strong>ExcelFile2.xls</strong>" that will overwrite previous versions that I would ideally like Access to pick up on. This range is <code>A14:O19</code> and will always be this range (i.e. static range).</p>
  
  <p>So in summary: I'd like to link Access to 2 data ranges from 2 respective Excel files to produce 2 separate tables available in Access. 1 of the source data ranges will be dynamic and the other will be static. I'd like Access to pick up on the new data if possible by simply overwriting the source Excel files with new versions of the exact same file name and path.</p>