I'm looking to import data from an internal website for my company into Access. I currently do this through excel but the data is so large it causes my spreadsheet to crash.
Is it possible to do this through Access?
I'm looking to import data from an internal website for my company into Access. I currently do this through excel but the data is so large it causes my spreadsheet to crash.
Is it possible to do this through Access?
Re: Web data import into Access - Is it possible?
The answer is 'maybe', it will depend on how your website page is designed and what access you have to it. However if it can be imported into Excel then it is likely (though not certain) that it can be imported into Access.
One simple way is to open the External Data tab on the Ribbon then Import > More > HTML Document. You then need to be able to access your website page as a file (rather than from a Browser).
If you only have access to it via a browser then it may be more problematic. You can try saving a 'snapshot' of the HTML after browsing to it with a Web Browser and then follow the above step, but again this will depend on how the web pages are designed. If they are only rendering the data then no actual HTML for that data will exist.
It is difficult to be more specific without more detailed information about how the web pages are constructed.
Don’t have an account yet? Register yourself now and be a part of our community!