Extract data from table on URL (to include png files)

[DavidSwift9]

Hi,



I am a new user to access. I would like to extract a table from a URL, it is 4 fields and has around 150 records. One of the fields is made up of png files, relatively small ones. Is it possible to extract all the text and png files straight into access without individually saving each picture and attaching it to a record?

Many thanks.

[June7]

Data can be extracted from web pages, not easy.

Bing: Access VBA download table from web page.

I don't think the images will get saved. Saving images files (or other file objects) into attachment field in table requires even more special coding. Review: https://www.accessforums.net/program...ton-38798.html

You might find this interesting https://www.accessforums.net/forms/a...her-34620.html

[AlexHedley]

I created a mini tutorial on how to download images from a website using Access

http://youtu.be/HMOE6LkoqW8

I prefer not to store files as attachments in a db as it will bloat it quite quickly.
You could store the filepath and filename in a field of the table.

For Tables you can use the HTML Library that you would need to Reference.
Loop through the DOM and Table elements and store each value that way.

Working with Images and OLE objects:
http://www.599cd.com/site/courselist...?key=AlexForum