Importing HTML using TransferText
I've been using the following method to import HTML data from a website:
DoCmd.TransferText acImportHTML, , "MyList", "http://www.server.com/MyList.htm", True
This has been working fine for 18 months. Then the ISP upgraded servers and it's quit working. I've been shopping other ISP's, but can't seem to get the code working again. Sometimes it works sporadically on some UNIX server, but seems to fail entirely on Windows servers.
Any ideas from you web gurus out there?