Library Database

[Carl Witte]

Hi I'm writing myself a database in MS Access 2007 (Vista) to catalog all my books. I want to grab from a website the title and author based upon ISBN. I've got the code to make the hyperlink. What I want to do now is download the hyperlink so I can parse it up and take the data (author, title, publish date) from the website. The parsing itself isn't tricky just programmically labor intensive. I just need help getting the information from that hyperlink into access. Thoughts or hints?

Here is what I've tried...

myfile = "http://www.amazon.com/exec/obidos/ISBN=" & strISBN & "/"
Application.FollowHyperlink myfile, , True

I was thinking I could use the sendkeys next but I'd rather find a better way.

[nico5038]

Much work, but there's an easier way by using a Webservice like described in http://search.cpan.org/~rjray/WebSer...B/API/Books.pm

To use this webservice in an Access application read: http://www.databasejournal.com/featu...le.php/3567511

Idea ?

Nic;o)

[Carl Witte]

Ok Nico. I'm an idiot thanks for pointing me in the right direction. I can do it in one line with no effort.
(where myfile is a string leading to an xml page)

ImportXML myFILE, acAppendData

First time import it with structure manually. Then just let access do the work. At that point you can easily massage the data to your hearts content.
Some days I'm so dumb it kills me. I can't belive it took me three days to figure this out.

Carl