Hi

Thank you for the advice, we can do this, but this doesnt help with the
other files we have already saved in the older format, these need to be
updated but will be too time consuming to do one at a time.

Thank you

"Bob Phillips" wrote:

Access has later file formats. Could you not change that job to output in a
later version?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michelle" wrote in message
...
Hi

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 - there are approx 350 of them!

Any ideas?

Thank you