读书人

bulk insert 遇到有关问题,在查询分析

发布时间: 2012-02-17 17:50:42 作者: rapoo

bulk insert 遇到问题,在查询分析器中能插入,而在vc中确不行
str= " BULK INSERT dbo.text FROM 'd:\1234.txt ' WITH (FIELDTERMINATOR = ', ', ROWTERMINATOR = '\n ') ";

//通过CDatabase对数据源进行操作;
CDatabase m_db;
m_db.Open( "suixin ",FALSE,FALSE,_T( "ODBC; "),TRUE);
TRY
{
m_db.ExecuteSQL(str);
}
CATCH(CDBException, e)
{
// The error code is in e-> m_nRetCode
}
END_CATCH

[解决办法]
抛出什么错误?

读书人网 >SQL Server

热点推荐