I am trying to download a livelink document, which presents as an Excel format, into an Access table.
When I run the code below, once the table is found, I am presented with the following error message - "database does not suport HTML pages". I have no idea what this error means or how to fix it.
My simple test code is as follows:
strFileName = "http://docweb.company.com/doc/livelink/Contact%20List?func=docfetcher.fetchdoc&nodeid=582331501
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xm
l, "tmpContact", strFileName, True
Is the docmd.transferspreadsheet method what I should be using? Or, should I be using something else - if so, what?