Export data Sql to Excel

i try to export whole data from sql to excel, but am not acess, following is command and message:-

Command:- EXEC xp_cmdshell 'bcp "select top(1) * from dbname.dbo.tblname" queryout "D:\file.txt" -U myid -P currentpwd –S abc\sqlexpress -c -t,'

Message is:-

SQLState = 08001, NativeError = 87

Error = [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Connection string is not valid [87].

SQLState = 08001, NativeError = 87

Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is config

ured to allow remote connections. For more information see SQL Server Books Online.

SQLState = S1T00, NativeError = 0

Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired

NULL

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa8y ago
Accepted answer
Hello

Check your instance name in connection string
Sanwar Ranwa8y ago
Hello

Please check these links

https://www.c-sharpcorner.com/UploadFile/cd7c2e/export-sql-data-to-excel-using-Asp-Net/

https://www.encodedna.com/2013/01/asp.net-export-to-excel.htm

https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx
Narinder Singh8y ago
sir, can you give me some example