Import From Website (1 Viewer)

[Diamond-Leopard]

So I have looked online and this doesnt seem to be something which is already set up within access so I ask the Gurus or Access found on this forum for a little guidance.

Lets say I have a url which holds all the sales I have made and I want to import all of that data into a table on access with one click.... I would want to link to the page... find the data I wanted and import that into the relevant fields in the table already created for importing this data.

Is this possible?

 

[June7]

Probably. Might be able to import from web page. If the site you want to download a table of data from offers an API, use it. Otherwise 'scraping' a web page can be complicated.

What research have you done?

Bing: Access import web page

Review https://social.msdn.microsoft.com/forums/en-US/50b61925-3c65-408e-8c26-f9a432ce9adf/importing-data-from-a-web-page-into-access-database