excel linked to access

F

Fuzzy31

Hello

I have an excel template liked to an access table. The date entered in on
the template is the primary key with no duplicates in access. I would like to
set up the link so a user could open the template to re-enter the report for
a past date and have it replace the data in access. Is this possible without
having to open access or the saved file from excel

Thank for your help
 
J

John Nurick

Probably it's possible to do this without opening Access, by writing
Excel VBA code that uses the DAO or ADO library to write to the Access
table.
 
Top