linked form

[hi there]

hello everyone,

i'm trying to set up a form in access and have the data automatically populate an excel worksheet. i don't want to have to export data from the table in access to excel each time i update a record. is there an easy way to link this form to my workbook in excel from access?

thanks all

 

[hi there]

Thanks for the reply Pat. I suppose I could link the worksheet to an Access table, but I think I would have to do that from Excel. I was hoping to find a solution on the Access end using VBA or some other trick.

Again thanks for the input