D
dpdodson
Problem: Getting Linked Access Table to Update.
Description: The linked Excel table contains data linked
to a 2nd Excel spreadsheet.
When the ACCESS-linked Excel file is manually opened and
saved, the linked data in ACCESS is updated.
When the ACCESS-linked Excel File is programtically (VBA
code) opened, and saved the linked data in ACCESS in not
updated.
Anyone got any ideas on this one.
Description: The linked Excel table contains data linked
to a 2nd Excel spreadsheet.
When the ACCESS-linked Excel file is manually opened and
saved, the linked data in ACCESS is updated.
When the ACCESS-linked Excel File is programtically (VBA
code) opened, and saved the linked data in ACCESS in not
updated.
Anyone got any ideas on this one.