Link HTML & Access through VBA Macro

[S.u.r.e.s.h.]

Dear Chandoo

Greetings.

I would like to create a command button in excel. This button should copy the content (3 column table format) from HTML page and paste the details in MS-Access.

Could you please help me in this macro?

Regards
Suresh.

 

[bobhc]

Good day Suresh and welcome to the forum, if you have not already done so please read this link, it will help you in using the forum.

http://chandoo.org/forum/forums/new-users-please-start-here.14/

As to your question why are you using more steps than needed, why not use Access to import the HTML file directly.
Excel/Import HTML Data/Buttons/copy/paste/access.....No need, by the time you have done this could have been drinking coffee.


Access/Import HTML document....Done

.