Updating excel from access
Is there something that changed in the linking process between access 97 and access 2003? Use the built-in Help that comes with Excel/Access 2. A lot of VBA code can be acquired by using the Macro Recorder. However, to update the Excel file in the end, I think you would need to export from Access at that point (and import that into Excel).
The spreadsheet is not write protected or otherwise in use. "I don't think you need to import anything into Access, you can link the Excel file to Access to get what you need.
however I would look at why you you are holding two 'base' data sets.
and maybe just have one and refer to it from both systems." id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3653759" / As someone else mentioned, having just one source is much preferred to having two "copies" that have the potential of getting out of sync." id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3653787" / That works, as does linking an Excel spreadsheet to the Access table.
Create a linked table in Access pointed to the Excel table.
For example, both programs can store large amounts of data, run powerful queries and analysis tools to slice and dice that data, and perform sophisticated calculations that return the data that you need.
When I go to the linked table and try to edit, I can't.
there's no obvious reason to me why this cant be done I get a "cant update" error.
Both the table and the sheet have the same primary key. We also share information about your use of our site with our social media, advertising and analytics partners.
After this is linked, it is just like a regular Access table - you just add it to your query like any other table.