vb如何将MS-SQL表的数据复制到MS-Access表,我尝试使用以下代码: ''''''''''''''' Dim AccessConn As new ystem.Data.OleDb.OleDbConnection(Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ AccessDB) AccessConn.Open( ) Dim AccessCommand As New System.Data.OleDb.OleDbCommand(INSERT INTO ResourceDetailGroup FROM [ResourceDetailGroup] IN''[SQLOLEDB; Driver = {SQL Server}; Server = SQLEXPRESS; Database = Database; Integrated Security = SSPI];,AccessConn AccessCommand.ExecuteNonQuery() AccessConn.Close () ''''''''''''''但是抛出语法错误在INSERT INTO声明中。 给出任何建议 谢谢...
vb how to Copy MS-SQL tables's Data to MS-Access Table , i tried with Following code: '''''''''''''''' Dim AccessConn As New ystem.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + AccessDB) AccessConn.Open() Dim AccessCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO ResourceDetailGroup FROM [ResourceDetailGroup] IN '' [SQLOLEDB;Driver={SQL Server};Server=SQLEXPRESS;Database=Database;Integrated Security=SSPI];", AccessConn) AccessCommand.ExecuteNonQuery() AccessConn.Close() ''''''''''''''''''''''''''' but throwing "Syntax error in INSERT INTO statement." give any suggestion for this Thanks ...
推荐答案使用此方法修复... Dim AccessCommand As New System.Data.OleDb.OleDbCommand(INSERT INTO+ sAccessTbl + SELECT * FROM [+ sSqlTbl +] IN''+ [ODBC; Driver = {SQL Server}; Server =+ gSqlDBServerName +; Database =+ gDB_SQLDatabase +;集成安全性= SSPI];,AccessConn fixed using this... Dim AccessCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO " + sAccessTbl + " SELECT * FROM [" + sSqlTbl + "] IN '' " + " [ODBC;Driver={SQL Server};Server=" + gSqlDBServerName + ";Database=" + gDB_SQLDatabase + ";Integrated Security=SSPI];", AccessConn)
更多推荐
将复制Sql表数据出错到Access表
发布评论