Docmd.Transfer Text HTML web import errors

[AvGuy]

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?

AvGuy

 

[CautionMP]

Thread moved to [navy]Microsoft: Access Modules (VBA Coding) > [/navy]DoCmd.TransferText HTML Import error