Updating access database from excel
There are several basic techniques that must be learned to ensure that the database structure will be solid.Design is an absolutely essential part of creating a database.Copy the contents of the spreadsheet to a new one, and deleted the old one (it wasn't a particularly important spreadsheet, thankfully), and everything was fine.I can only assume that somehow the file had become corrupted.
For example, if you run a store, you would create a Customers table, a Products table and an Invoices table.
To help you along, Access contains a whole series of Wizards to guide you through the process.
This MSAccess tutorial follows a step-by-step approach to the creation and development of a commercial database application. That means that you have to design the database before you actually start to write it.
I opened this spreadsheet, checked that this was still working and autoupdating with current installation of MS Excel and any new automatic office updates (which it did work with), and then just reopened the original spreadsheet. In my instance I was using a particular add-in called PI Datalink.
Somehow PI's Calculate method was no longer running during the normal workbook recalculate.