Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Macro Output Query to Excel - Cannot Read File

Discussion in 'Information Technology' started by Ruth, Nov 8, 2005.

  1. Ruth

    Ruth
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Microcosm and Macrocosm Gurmat Vichaar Mar 20, 2009
    Adobe Unruffled by Macromedia Restatement (AP) Interfaith Dialogues May 4, 2005
    Macromedia Flash animation and designing. Interfaith Dialogues Oct 21, 2004
    Sikh News Punjab wheat output to be highest in 7 years (Reuters via Yahoo! India News) Breaking News May 15, 2008
    Sikh News Punjab fears shortfall of 2.4m tons in wheat output (Dawn) Breaking News Apr 7, 2008

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    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

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Ruth" <ruthhays@gmail.com> wrote in message
    news:1131434787.608917.324440@g43g2000cwa.googlegroups.com...
    >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
    >
     
  4. Ruth

    Ruth
    Expand Collapse
    Guest

    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
     

Share This Page