Macro Output Query to Excel - Cannot Read File

R

Ruth

I have a database that I started two years ago for a client with Access
2000. I have a number of queries that I was outputting to Excel (by
using macros). I then referenced the results (things like Total
Employees [contained in one query], Number of Terminations [contained
in another]) as links in an Excel spreadsheet where I formatted,
sliced, diced, etc. Everything worked perfectly!

After the upgrade to Access 2003, the files that Access outputs to
Excel (by using the same macros) are no longer readable as links by
Excel.

It doesn't matter what Excel format I specify (I've tried that); It
doesn't help if I create a new macro (I've tried that).

I can get around the problem by opening the file in Excel 2003 then
saving, and responding to the prompt to save it with the latest Excel
format. The dialog box indicates that it is currently in an Excel
5.0/95 format -- even though I specified the latest version in the
macro.

Has anyone else had this problem? My current solution is an Excel macro
that opens and resaves all of the files, but that is just ridiculous!
This should work!

Thanks for any advice or commiseration.

Ruth
 
A

Allen Browne

Does your issue relate to the fact that Microsoft broke the ability to write
to Excel when they released Serivce Pack 3 for Office 2003 (and a hotfix for
Office 2002)?

Details in:
Cannot change, add, or delete data in linked Excel tables in Access 2002
or 2003
at:
http://support.microsoft.com/kb/904953/en-us
 
R

Ruth

Hi Allen,
Thanks for your response! That looks like that may be it, even though I
am not linking directly to table data. The workaround they suggest is
the one I'm using (open file, save changes, etc.). At least now I have
an official Microsoft document to refer to to explain the behavior.

Thanks very much!
Ruth
 
Top