将excel工作表导入现有的访问数据库表 [英] Import excel worksheet into existing access database table
问题描述
公共 Sub ImportExcelToAccess()
Dim AccessConn As 新系统。 Data.OleDb.OleDbConnection( Provider = Microsoft.Jet.OLEDB.4.0;& _
数据源= c:\db1.mdb)
AccessConn.Open()
' 新表
Dim AccessCommand As 新 System.Data。 OleDb.OleDbCommand( SELECT * INTO [tblSheet1] FROM
[Excel 8.0; DATABASE = c:\ Book1.xls; HDR = NO; IMEX = 1]。[Sheet1 $],AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
结束 Sub
我尝试过:
我正在尝试使用vb.net/ado.net将Excel工作表导入现有的Access数据库表。 select语句可以很好地创建一个新表,但是我无法获得填充现有
表的INSERT语句的正确语法。 div class =h2_lin>解决方案
,AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
结束 Sub
我尝试了什么:
我正在尝试将Excel工作表导入现有的使用vb.net/ado.net访问数据库表。select语句可以正常工作
用于创建新表,但是我无法获得正确填充INSERT语句的语法现有的
表。
我给了你两篇CodeProject文章的链接,这些文章可以帮助你在如何将Excel导入ACCESS? [ ^ ]。请不要重新发布相同的问题,编辑原文。
Public Sub ImportExcelToAccess()
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\db1.mdb")
AccessConn.Open()
'New table
Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [tblSheet1] FROM
[Excel 8.0;DATABASE=c:\Book1.xls;HDR=NO;IMEX=1].[Sheet1$]", AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
End Sub
What I have tried:
I am trying to import an Excel worksheet into an existing Access database table using vb.net/ado.net. The "select" statement works fine
for creating a new table, but I cannot get the correct syntax for an "INSERT" statement that will populate an existing
table.
", AccessConn) AccessCommand.ExecuteNonQuery() AccessConn.Close() End Sub
What I have tried:
I am trying to import an Excel worksheet into an existing Access database table using vb.net/ado.net. The "select" statement works fine
for creating a new table, but I cannot get the correct syntax for an "INSERT" statement that will populate an existing
table.
I gave you the links to two CodeProject articles that would help you to do this in your original of this question at How can I import excel to ACCESS ?[^]. Please do not repost the same question, edit the original.
这篇关于将excel工作表导入现有的访问数据库表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!