[Ramji]

Hi
I have problems exporting data from Microsoft Access to Micorosoft Excel.

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 ExporttoExcelWorkerdatabase_Click()
'DoCmd.TransferSpreadsheet acExport, 8, "Export to Excel Worker database", "G:ADMINISTRATIONHuman ResourceHR AdministrationWorkers Database", True
DoCmd.TransferSpreadsheet acExport, 8, "Export to Excel Worker database", "G:ADMINISTRATIONHuman ResourceWorkers Database", True

MsgBox "Export data is done! Pease refer to G:ADMINISTRATIONHuman ResourceWorkers 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

[mcbarker]

I can think of two possibilities... Either the drives or directory paths have been changed or someone has altered the code, or you or someone else has disabled macros (check your security settings).

[Ramji]

thanks for your reply. anyway I have settled the issues. I have just deleted the worker database.xls and click the export button. its working fine.

Regards
Ramji