连接访问数据库并写入表
我有一张 Excel 发票表,我想将发票中的信息写入 Access 文件中的表中。我的以下代码是:
Private Sub Button66_Click()
Dim con As New ADODB.Connection
Dim connectionString As String
Dim sql As String
connectionString = "DBQ=c:\Users\Public\Public Desktop\InvoiceRecords.mdb; Driver={Microsoft Access Driver (*.mdb)};"
con.Open connectionString
sql = "insert into Invoices (Customer, Address) values(G6, G7)"
con.Execute sql
MsgBox "Values entered", vbInformation
con.Close
Set con = Nothing
End Sub
但是,当我运行它时,我收到运行时错误 '-2147217904 (80040e10)';输入的参数太少。 我不太确定这是什么。 有什么想法或建议吗?非常感谢!
I have an excel invoice sheet and I want to write the information from the invoice to a table in an Access file. My following code is:
Private Sub Button66_Click()
Dim con As New ADODB.Connection
Dim connectionString As String
Dim sql As String
connectionString = "DBQ=c:\Users\Public\Public Desktop\InvoiceRecords.mdb; Driver={Microsoft Access Driver (*.mdb)};"
con.Open connectionString
sql = "insert into Invoices (Customer, Address) values(G6, G7)"
con.Execute sql
MsgBox "Values entered", vbInformation
con.Close
Set con = Nothing
End Sub
However, when I run it I get a runtime-error '-2147217904 (80040e10)'; Too few parametersentered.
I'm not what sure what this is.
Any ideas or suggestions? Thanks a bunch!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我认为问题是您试图获取 INSERT 查询中单元格 G6 和 G7 的值。您需要将它们连接到插入查询中。
以这种方式构建 sql 命令会使您容易受到 SQL 注入的攻击。更好的替代方法是使用参数化查询。
您还应该使用 Jet 驱动程序来连接,而不是 ODBC 驱动程序。请改用此连接字符串。
I think the problem is you're trying to get at the values of cells G6 and G7 in your INSERT query. You need to concatenate them into your insert query instead.
Building your sql commands this way makes you vulnerable to SQL injection. A better alternative is to use a parameterized query.
You should also use the Jet driver to connect, instead of the ODBC driver. Use this connection string instead.