G
Guest
I'm quite familiar with having an Excel worksheet linked into Access.
However, I have a coworker asking me about having a reverse link - where an
Access table (or query) is linked to an Excel worksheet, and any updates to
the table are reflected in Excel.
I've never done something like that before. Is it possible? And if so, what
happens if new columns are added to the underlying Access table?
Does the answer change if the "table" being linked from Access is actually a
query or an ODBC-linked table from SQL Server?
Thx.
However, I have a coworker asking me about having a reverse link - where an
Access table (or query) is linked to an Excel worksheet, and any updates to
the table are reflected in Excel.
I've never done something like that before. Is it possible? And if so, what
happens if new columns are added to the underlying Access table?
Does the answer change if the "table" being linked from Access is actually a
query or an ODBC-linked table from SQL Server?
Thx.