DoCmd.TransferText HTML Import error

[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]

Can you link to the HTML table (File -> Get External Data... -> Link Tables...)?

I wonder if there isn't a timeout issue that [tt]TransferText[/tt] doesn't tell you about.

CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[AvGuy]

Don't know if I can link - don't think so. Problem is not with my code; it's been running fine for 18 months. Problems is with the servers and what they need to make this kind of connection.

AvGuy