How To Automatically Pull Data From A Database Into Excel. Position yourself on a new worksheet in the cell where you want to insert your. In the navigator window, select the database and then the table that you would like to import in excel and click on load.
Under refresh control, you get a command refresh every (by default 60 minutes), you can change it. First of all open a new excel sheet, in sheet 1, insert data as in the case below. Go open up your file in a browser.