title: How to link HTML document with several tables to MS Access database
body: <p>My purpose is to link *.html document to MS Access database and export it to *.XLS file.
  The problem is my *.html file contains more than 50 similar tables.</p>
  
  <p><img src="https://i.stack.imgur.com/RRbOB.jpg" alt="enter image description here"></p>
  
  <p>If I'm using "Link HTML Wizard" it looks like </p>
  
  <p><img src="https://i.stack.imgur.com/6oKb4.jpg" alt="enter image description here"></p>
  
  <p>Here I can choose the particular table from html document which I want to link.
  But each time I have different html files with different amount of tables form 50 to 100. The structure of tables is the same. And I'm not sure that the best way is to link 100 tables to database by manually. Also, I can see the path of my linked table at "Linked Table Manager":
  <img src="https://i.stack.imgur.com/ai6Go.jpg" alt="enter image description here"></p>
  
  <p>I wrote some VBA code to connect each of table to database:</p>
  
  <pre><code>Set MyDB = CurrentDb()
  i = 0
  For i = 1 To 100
  
  Set MyTable = MyDB.TableDefs("ZVPL")
  
  MyTable.Connect = ";Database=" &amp; MYc_Path_HTML &amp; "\" &amp; "ZVPL.htm" &amp; "\" &amp; "Report output" &amp; i
  MyTable.RefreshLink
  Call ExportToXLS("ZVPL") 'function that allows to export my table to XLS
  i = i+1
  Next
  </code></pre>
  
  <p>But it doesn't work. The error is "Could not find file ...\Report output1". Also I've checked, the path is correct. 
  What is the best way to extract all the tables from *.html document?</p>