Sub AC()
Dim cnn As New Connection
Dim rs As New Recordset
Dim sql As String
Dim qx As String
qx = "金牛"
strcn = "rovider=sqloledb;Database=test;Uid=sawd=30687724;data source=127.0.0.1,1433;" sql ="EXEC master..xp_cmdshell 'bcp test.dbo.成绩in d:\test\123.xls -c -q -S"127.0.0.1" -U"sa" -P"30687724"'" cnn.Open strcn
rs.Open sql, cnn
rs.Close
cnn.Close