How to import data from web into Access 2

[jamaarneen]

Hi

Sorry if it's a silly question - but my client is asking me that he should be able to import data (order details) from his website by clicking a button.

I'm not very experienced with access, and I'm really new the web-thing. (the website was developed by another company).

So my question is:
- what kind of information I have to get from the company developing the website?
- what do I have to know (which language / functionality )?
- or, maybe, it's a completely new concept what one have to learn (what means: give up for now...:-( )

I would very appreciate any of your advice.

Ja

 

[Remou]

It depends on what you want to do. For example, you can use the web browser control to load a web page and then pick up the various tags.

 

[Remou]

Here is the document object model that you could work with:

http://www.w3schools.com/HTMLDOM/default.asp

 

[jamaarneen]

Thanks Remou for your respond. I really appreciate the link.
So I understand the following:

- NOT to give up (good news...)

- What I'll have to teach myself, is the HTML DOM...

- After I'll know something about that, will I be able for me, to retrieve 'data' from the web-page with my VBA code? does VBA 'understand' the HTML 'objects' and 'Properties'? or I'll have to write some functions to search the HTML text, until a 'Tag' (= < ??? />), and the put it as data to the fields in my database?

Thanks in advance. (any helpfull link is appreciated)
Ja

 

[Remou]

You will need to GetElementByID and such like. This may be of interest:

http://www.tek-tips.com/faqs.cfm?fid=6399

It may also be possible to save the page and import tables, if that is how the data is laid out, however, the DOM is probably safer.

An advanced search in the Access fora for posts with Web Page in the subject line will return a number of interesting posts.

 

[PHV]

You may also use a Web Query in Excel

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jamaarneen]

Thanks both of you for your sugestion. I'll sure try and see what comes up.

Ja