Forum Discussion
Access not finding the right Excell file to use
I updated the Excell file that my Access estimating program uses and Access won't use it. It automatically goes to an old file that I can't find on my computer.
Sorry but that isn't true
The screenshot shows an Excel file which was opened before it was opened as a linked Excel table in Access
In fact you can also link to an already open Excel file from Access and then open it
NOTE:
It is possible to edit Excel files directly in Access - see Edit Linked Excel Data from Access (isladogs.co.uk)
However,, the linked Excel table is of course read only in Access if it is already open in Excel.
