how can i export table from sql to Excel using
OpenRowSet function

That is for importing data into SQL Server not exporting. Take a look at SQL
Server Integration Services (SSIS) instead.

--
Andrew J. Kelly SQL MVP

"Meir Azulay" <meiraz (AT) hotmail (DOT) com> wrote

Hello Meir,

I presume you are using OPENROWSET to go against Excel rather than SQL Server
although you can use it to go against SQL Server.

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

I would be using SSIS or DTS to do the export to Excel.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com