Excel files update from Access

By Michelle2
Nov 9, 2005
  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.

Similar Topics

Add your comment to this article

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...