How to import data from a webpage?

[dannydanny]

Hi,

I`m using Access 2000 and I want to import data from a webpage into my access database. It is possible to do easily? I searched the web and found software that I have to buy, so I thought maybe there is no easy solution.

How about a way to import the data into excel, then from excel to Access?

Any ideas much appreciated,
Danny

 

[jrbarnett]

You can either read the HTML file in as a text file, then parse it to find the appropriate data, or check that it actually is directly in that file and not taken from a database driving the website - which is quite usual if it is frequently changing. You will need to experiment a bit to find the appropriate database location but it shouldn't be too difficult.

John

 

[BattleDroid42]

You should not have to buy any software. It should be just a simple matter of saving the page as text and using the import wizard and/or an import specification in Access to import the data. I would be better though to obtain access to the database behind the page if you need to do this often.

 

[dannydanny]

Hi all,

Thanks for the ideas. I might try reading in the html as text. Since I need to automate the process I might try to write a VBS script. I`ll ask the guys in the VBS forum.

Thanks again,
Danny

 

[jrbarnett]

If you have got Excel, have you considered a web query? It should be easy to copy the data over to access afterwards?

John

 

[danvlas]

Private Sub UnitType_DblClick(Cancel As Integer)
On Error GoTo Err_UnitType_DblClick

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "UnitTypesForm"
DoCmd.OpenForm stDocname, , , stLinkCriteria, , acDialog
Me.Requery

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html