TechSpot

Excel files update from Access

By Michelle2
Nov 9, 2005
Topic Status:
Not open for further replies.
  1. I have a problem with an Excel file that I want to auto update against data
    in other Excel files - unfortunately the source files are created by Access
    and so are Excel 95 format. The update works fine if the source files are
    open but gives an error message if not. If I re-save the source file as Excel
    2000 it works without the error. There will be circa 240 source files and
    when updated by Access will be over written so it is not feasible to manually
    convert the files.

    Any ideas or has MS beaten me on this one? :blackeye:
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.