Hello friends

 

We learn in this blog HOW TO IMPORT AN ACCESS DATABASE INTO EXCEL.

 

Sometimes you might need to pull items from an access database and put them into excel so you can organize them for a report or presentation. This process saves a lot of time when going through large amount of data versus sorting through a report.

FOLLOWING  STEPS  OF  HOW  TO  IMPORT  AN  ACCESS  DATA  INTO  EXCEL :

 STEP-1   open up a new workbook in excel.


 STEP-2   Click on data tab.


 STEP-3    Click on From Access.

  STEP-4    Browse to the location of database you want to import.
 


















  STEP-5    Select the one you want to get the data from.

  STEP-6    Select how the data will appear in the workbook and choose the cell where you want it to start.

STEP-7     Click OK.


STEP-8     The table data will be placed in excel with the design tab, so you can organize the look and feel for presenting the data.