Query output to Excel not working

[applevacross]

Windows XP Pro/Office 2000

I was able to output to excel before fine, now all of a sudden I cannot. I keep getting a message when I go Tools>Office Links>Analyze with MS Excel:

"Cannot access "xxxvac_Inv_DBQuery.xls"

It's wierd. It won't output the data, but it still creates the spreadsheet file.

Any Idea's?

Thanks to all in advance, your help is greatly appreciated!

 

[KenHigg]

Hum... Give it a more simple name, make sure the file you are creating doesn't already exist and or is not open. Make sure the query is returning rows!