Updating a linked table in access
I have a table in Access that is linked to an Excel Workbook that contains part numbers and formulas.
Why doesn't it pick up the information the first time?If the table is open in Access and you try to open the original Excel workbook at the same time, Excel will say that it can't access the file.If you have the Excel file open, you can open the Access table to which the Excel data is linked.Not all of my part numbers are being picked up in Access even though they exist in the Excel Workbook.It's not a formatting issue either because everything is formatted the same and all the other hundreds of part numbers and quantities were picked up.
Search for updating a linked table in access:
Choose your site and your list in the following menus.