By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,280 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Linking to an HTML table on a Server

P: n/a
I am trying to use Access 2000 to link to an HTML table on a web server.
When I use File / Get External Data / Link Tables and I enter the URL for
the web file, I get the error

'http://.../orders.htm' is not a valid account name.

The server does not require a login, so I don't know why Access is referring
to an account name. Does anyone know what might be going on?

In addition to that general appeal for assistance, I have two specific
questions regarding HTML tables:

1) I have never linked to a file on a web server. The help file claims that
Access can do it, but as far as I know, that is an unfulfilled promise. Has
anyone out there successfully linked to a web HTML table? Can you confirm
that this feature works? Can you give me a URL to a sample file, in case the
problem is with my server?

2) Instead of using the File / Get External Data / Link Tables wizard, I
would like to build the link in code. When I try, however, I get an error
message indicating that I have not properly defined the table fields. Can
anyone point me to some sample code that shows how to link to a HTML table
using code?
Thanks.
-Todd Matson
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.