I have a link called Export to Excel Workers database from my Inventory System which was developed using Microsoft Access. Usually Once I click the Export to Excel button I will see the information transfers to my workers database.xls which is in another location. Before one week it was okay. Now it seems different.

Now after I click the export button from my access I cannot able to transfer the information to my excel file. Instead, the excel file is blank. There is no data.
Data missing. And also I have tried replacing the Workers Database.xls from my backup. Once I replace backup I can able to see the data inside the workers database.xls but after clicking the export button again the same problem. The data is missing.

The below is the the event procudure for this function which was retrieved from my MS Access properties >> event:-
Private Sub Export_to_Excel_Worker_database_Click()
'DoCmd.TransferSpreadsheet acExport, 8, "Export to Excel Worker database", "G:\ADMINISTRATION\Human Resource\HR Administration\Workers Database", True
DoCmd.TransferSpreadsheet acExport, 8, "Export to Excel Worker database", "G:\ADMINISTRATION\Human Resource\Workers Database", True

MsgBox "Export data is done! Pease refer to G:\ADMINISTRATION\Human Resource\Workers Database.xls", vbInformation, "Message from the Author"

End Sub

If anybody knows how to export my file from my access to excel pls let me know. This is very very urgent. Pls reply me ASAP.

Regars
Ramji