how data export tally to excel

For the control that you are updating (in a form), create an after_update event that runs a query to calculate the new tally and then export your query to an excel spreadsheet using the DoCmd.TransferSpreadsheet function.

For the importation, you would also use the DoCmd.TransferSpreadsheet.

Without specific details, this is the best I can offer. You can research DoCmd.TransferSpreadsheet by using Google.

For the Query, you can either use the Query by Design functionality of Access or write your SQL statement directly in VBA for inclusion in your After_Update event.