469,913 Members | 2,534 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,913 developers. It's quick & easy.

Library Database

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...

Expand|Select|Wrap|Line Numbers
  1. myfile = "http://www.amazon.com/exec/obidos/ISBN=" & strISBN & "/"
  2. Application.FollowHyperlink myfile, , True
  3.  
I was thinking I could use the sendkeys next but I'd rather find a better way.
Mar 23 '08 #1
2 1434
nico5038
3,080 Expert 2GB
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)
Mar 23 '08 #2
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)
Expand|Select|Wrap|Line Numbers
  1. 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
Mar 25 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Zippy | last post: by
reply views Thread by Maciej Sobczak | last post: by
3 posts views Thread by kaisersose1995 | last post: by
8 posts views Thread by Mihai Velicu | last post: by
reply views Thread by drawing in aspnet | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.