导出成EXCEl出现错误
执行以下语句
EXEC master..xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout "d:\ authors.xls" -c -q -S(local) -Usa -P'
出现错误提示:
SQLState = 28000, NativeError = 18456
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.