title: VBA Access -> Automated Import an Excel Spreadsheet w/ HYPERLINKS
body: <p>Looking for a wee bit of help here in regards to this. I have a fairly simple Excel datasheet that needs to be input into an Access database in order to be manipulated. However, the data spreadsheet includes a hyperlink. When I try to use my code it gives import errors for the hyperlink field and imports nothing but a blank field.</p>
  
  <p>I am absolutely clueless - can anyone help me on this one? I am trying to use my typical method of importing Excels into Access (my code imports multiple excels at once based on array) - which is below:</p>
  
  <pre><code>DoCmd.TransferSpreadsheet acImport, , ls_tblImport, varFileArray(intCurrentFileNumber, 0) &amp; varFileArray(intCurrentFileNumber, 1), True, "A1:BM" &amp; ls_last_row
  </code></pre>
  
  <p><strong>Please Note: The hyperlinks I am trying to import are not just URLs, but also Text for the URL.</strong> I wish I could just import the Hyperlink text, but sadly that isn't an option.</p>