[AccessD] Getting internet data

Haslett, Andrew andrew.haslett at ilc.gov.au
Wed Jan 28 17:57:58 CST 2004


Might want to check out this article. Looks like this feature will soon be
removed:
http://support.microsoft.com/?kbid=834489 

-----Original Message-----
From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] 
Sent: Thursday, 29 January 2004 8:06 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Getting internet data

You may be able to 'browse' to secured sites, with the following URL:

http://username:password@www.website.com

This works for sites that use plain text password security, if you are
prompted for a domain, along with a name and password, then the URL 'format'
above won't work, but IE can be setup to use your currently logged on
credentials.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps - IT
Helps
Sent: Wednesday, January 28, 2004 2:53 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Getting internet data



I done that before (and still using it) with a HTTP control from IP Works (I
believe they changed name into something else).
You can get the page in a string and analyse it further.
I believe there is a basic control from MS also in Access or VB, a HTTP
control.

Only one thing I don't know and is the tricky part... The password.
No experiance in that one. But you should look at a HTTP control.

I have my first code done with the XML parser. There is a HTTP XML parser
to, maybe this can do the trick to.

Erwin
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Wednesday, January 28, 2004 8:03 PM
To: AccessD
Subject: [AccessD] Getting internet data

I need to get some internet data into a db.  In order to do that I need to
"navigate", specifically I have to enter a username / password which will
bring me to a specific page.  After that clicking on tabs at the top take me
to other pages I'd also like to get data off of.

Does anyone know how to do this from VBA?

John W. Colby
www.ColbyConsulting.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

IMPORTANT - PLEASE READ ******************** 
This email and any files transmitted with it are confidential and may 
contain information protected by law from disclosure. 
If you have received this message in error, please notify the sender 
immediately and delete this email from your system. 
No warranty is given that this email or files, if attached to this 
email, are free from computer viruses or other defects. They 
are provided on the basis the user assumes all responsibility for 
loss, damage or consequence resulting directly or indirectly from 
their use, whether caused by the negligence of the sender or not.


More information about the AccessD mailing list