Hello EE experts,
I need help automating data pull from website into excel or access. The data span several pages (about 30 pages) based on dateFrom and DateTo and page number. Each page of the report has 500 records with the a header (501) records. Here is an example of the URL masking the login id and password :
I am looking a solution that will allow me to enter the date range as well as page number to pull the data.
I can pull the data using Data -> From Others Sources --> From XML Data Import, but looking for a streamlined process that will allow some automation.
Thanks in advance for your assistance.