Hello,
I have to repeatedly download and import an xlsx spreadsheet to an Access DB from a website that is failing using docmd.transferspreadsheet.
It's because of a known issue, with the downloaded Excel file not being fully compliant which seems to be typical of many websites.
Simply opening / saving the file in Excel solves the problem; I can then import ok.
Apart from being a clunky solution, my problem is our Access DB isn't always on a PC with Excel installed.
I can use online services which convert an xlsx file to a csv and import, but this too seems like a clunky solution.
And no luck on getting the website to create a correct xlsx...
Are there any known solutions here? Surely an Office product like Access should be able to open a file that Excel can?
Like I say, a known problem and several workarounds about - most requiring Excel though. Another is changing the xlxs extension to htm, but doesn't work for me.
Are there any other ideas?
Thanks in advance.
mrswas