exporting an Access textbox value to a cell in existing Excel file

[getrighteous]

Let's say I have a spreadsheet called "Excelfile.xls" and an Access DB form with a single textbox and a submit button. How can I copy the textbox entry to cell A1 of the spreadsheet when the submit button is clicked?

 

[MazeWorX]

Take a look at the "TransferSpreadsheet method" in access help

you could save the data to a table then transfer it to a spreadsheet