Export an entire table into a XML file with Excel format

Hello everybody:
Who knows how can I do to export an entire table to a XML file with Excel
format (font, number, aligment, etc) ?
Thanks
Richard_SQL,
I'm not entirely clear what you mean by "XML file with Excel format"?
This is not something typically done at the back end. However some of
the work can be done for you already by using the FOR XML clause of the
SELECT statment. You probably need to use the Microsoft Office APIs to
manipulate an excel worksheet, with something like VBA.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Richard_SQL wrote:
> Hello everybody:
> Who knows how can I do to export an entire table to a XML file with Excel
> format (font, number, aligment, etc) ?
> Thanks
>