Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 19th, 2006, 02:19 PM
Registered User
 
Join Date: Apr 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?

AvGuy

AvGuy





Similar Threads
Thread Thread Starter Forum Replies Last Post
TransferText Decimals Issue Pavesa Access 0 April 23rd, 2008 06:48 PM
TransferText Ignores Index in Import Specification nancyb Access VBA 1 September 29th, 2006 05:21 PM
doCmd.TransferText d_olivastro VB Databases Basics 1 March 31st, 2006 12:06 AM
TransferText method sc-prgmr Access VBA 0 October 12th, 2005 09:46 AM
transfertext and dates choatec Access 2 February 24th, 2004 09:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.