Question Access (1 Viewer)

[sree]

I am entering data in access entry view, I would like these data to update to excel directly (lively).
Not exporting after finished entry. Is there any idea to do this ?

 

[Niroth]

Why would you want to do that? Wouldn't it be better to do everything in Access? It already has most of the functions that Excel has.

 

[boblarson]

I am entering data in access entry view, I would like these data to update to excel directly (lively).
Not exporting after finished entry. Is there any idea to do this ?

The only way you would get to do that is to have people enter in the Excel file directly and use the Sharing mode of Excel. You can't update a linked Excel sheet from Access.