HiI have trouble updating the linked table manager in access to an excel file. After updating the linked table, access does not pick up the new values from row 200 onwards. It just returns to the old data. Pls assist. Thanks.
HiI have trouble updating the linked table manager in access to an excel file. After updating the linked table, access does not pick up the new values from row 200 onwards. It just returns to the old data. Pls assist. Thanks.
Please elaborate a bit more. Do you get any messages? How do you the data returned is from the linked Excel file? How are you viewing the data, via form, query, directly from the table?