Access to Excel

[#1]

Hi,

I have access database tables which I can able to see front end I need to send the data into excel . Could  anyone let me know how do I need to send to excel as I don't have data in table. only the data which I have is in front end.

Thanks.

[jduenyas]

If you have the data in the front end it must come from either a table or a query.

Here is the command to send it to Excel:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryOrTable", "C:\YourLocation", True, ""

"QueryOrTable" = the data on your front end

"C:\YourLocation" =  where you want to store the Excel file

Good luck