SQL 2008 export error

gmollineau
gmollineau used Ask the Experts™
on
hi,

please see attached file for error I am getting when I try to export to excel 2007. I have excel for office 365 installed on my computer.
any help will be appreciated.
thanks
sql2008r2exporterror.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
HuaMin ChenProblem resolver

Commented:
You can choose Backup and then use the default like the below (instead of having output to Excel)
43r.png

Author

Commented:
hi,

thanks for the information, however we would like the output to be in excel format.

Author

Commented:
hi,

thanks for the link, however we did a work around, we copied and saved as a csv file then open/save as a delimited.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial