Thank you that did the trick.

Is there a way I can run the procedure from other databases on the same server without having to copy into each database I want to run it on.

Thanks

s

I must add a thank you, this is saving me a great deal of time.

Basically if your first field/column contains only nulls or no data, you will get the excel error on opening the output file and the file will not open at all....

Igore my previous post, just figured it out. Great work.

Thanks

sidni

For some of my Tables I get the following errors, which I don't know if anyone come across these. I have no idea how to try and fix these:

1. The...

I have tried this and it seems to work fine, however it does not recognise excel when I tried to open although it opens it and my main point is...