Processing Excel Extension using Microsoft Access - thoriqaziz.com

thoriqaziz.com

Do your hobby

Processing Excel Extension using Microsoft Access

Share This
Recently, I have been confronted with case where there are a lot of data in excel, and from it I wanna delete the spesific records. Consequently, previously I deleted the records manually, whereas the data was pretty much, so it needed long time to do that. The solution is, if data to be deleted can be grouped, you can use function ascending or descending that provided in Excel. But, something that I wanna share here is when the function in excel have not been able to give solution of the problem, maybe you can try to integrate between Microsoft Excel and Microsoft Access. The steps are:
  1. Open Microsoft Access.
  2. Right Click to the table, Import; Excel and browse your excel file.   
     
  3. Follow the instructions until Finish.
  4. After process finished, now time for data processing using query in access.
If anyone wants to ask, please leaves comment below. Thank you!

No comments:

Post a Comment

Pages