Hi All,
Can someone please help me with something. I'm currently trying to link a table in Access to an Excel Sheet, so that when the Access table is updated it is reflected in Excel. I'm looking at it and i don't see how i can do it as when i've linked the tables I can only delete information from Excel and not from Access.
Is there a way to reversed the priviledges? So that excel is only viewable and of the changes to the file come from Access only?
Can someone please help me with something. I'm currently trying to link a table in Access to an Excel Sheet, so that when the Access table is updated it is reflected in Excel. I'm looking at it and i don't see how i can do it as when i've linked the tables I can only delete information from Excel and not from Access.
Is there a way to reversed the priviledges? So that excel is only viewable and of the changes to the file come from Access only?
