Loading Files from Internet

  • Thread starter Thread starter Nigel Brooks
  • Start date Start date
N

Nigel Brooks

Hopefully this is the right place to ask.

I need to be able to load a large number of MS Word and image (JPG/GIF)
files from a web server (which I don't control but have access to) into an
Access DB.

(These are consultant CVs and photos which have been uploaded to the web
server in response to online job adverts).

There are too many to manually load (about 1,000) so I'm looking to automate
the process.

My Access table has 4 relevant fields:

1. CV_URL - URL of the CV I need to download
2. Photo_URL - URL of the Photo I need to download
3. CV - OLE field where I want to store the downloaded CV
4. Photo - OLE field where I want to store the downloaded Photo

I need to write an SQL query, or a VBA procedure, that will step through
this table, using the CV and Photo URLs to retrieve the CVs and Photos from
the web and store them in the table.

I'll need to be able to handle likely error conditions (such as invalid URL,
inaccessible web server, page not found, etc).

Any pointers very gratefully received.

Nigel
 
I have a comment, but not a solution...

Access does not handle images and documents well, and given the number you
have, it may bloat out to the max file size. The generally accepeted way to
do this is to have the docs/pics in a specific folder, and then have the
path to the item in the table.

I have no idea how you could code the actual importing/downloading of the
files, other than using a web grabber type application (I use tools from
Ficstar software every day).

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
Sorry to comment on my own post but forgot to say I am using Access 2002 and
backward compatibility to earlier versions isn't an issue.

Nigel
 
Back
Top