如何将数据从SQL Server 2008导入到MS-Excel

我得到了自己的解决方案..



打开MsExcel

转到数据选项卡

从其他来源中选择

选择SQL Server

选择服务器名称和Windows身份验证/提供用户名和密码

导入数据

I got a solution from my self..

Open MsExcel
Go to Data tab
Choose From Other Sources
Choose SQL Server
Choose server name and windows authentication/supply username and password
Import data

嘿，



请参阅此链接

http://support.microsoft.com/kb/321686 [ ^ ]



最好的运气

快乐编码：）

Hey,

refer this link
http://support.microsoft.com/kb/321686[^]

Best Luck
Happy Coding :)

看到这个



http://dotnetslackers.com/articles/sql/Importing-MS-Excel -data-to-SQL-Server-2008.aspx [ ^ ]



http://social.msdn.microsoft。 com /论坛/ en / vbide / thread / 133b07b4-9bed-4ecc-9da9-7a1a53a7eab3 [ ^ ]





http://www.66pacific.com/sql_server_export_to_excel.aspx [ ^ ]

see this

http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx[^]

http://social.msdn.microsoft.com/Forums/en/vbide/thread/133b07b4-9bed-4ecc-9da9-7a1a53a7eab3[^]


http://www.66pacific.com/sql_server_export_to_excel.aspx[^]