Friday, February 17, 2012

export SQLExpress2005 to Access/Excel?

it seems that the SQLExpress2005 Management Studio Express has no DTS
functionality ... is there a way to automatically export an SQLExpress2005
database (or parts of it) to Access and/or Excel ?
thanks
-Michael
hi Michael,
Michael Peters wrote:
> it seems that the SQLExpress2005 Management Studio Express has no DTS
> functionality ... is there a way to automatically export an
> SQLExpress2005 database (or parts of it) to Access and/or Excel ?
>
not directly, but if you have and already created Access database or Excel
file, you can import/export via linked server,
http://msdn2.microsoft.com/en-us/library/ms190479.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment