also @ TechSpot: Google+ Local leverages Zagat for crowdsourced business reviews

TechSpot

Excel files update from Access

Discussion in 'Software Apps' started by Michelle2, Nov 9, 2005.

Thread Status:
Not open for further replies.
  1. Michelle2 Newcomer, in training

    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:
Thread Status:
Not open for further replies.