Microsoft Access INSERT INTO错误

本文介绍了Microsoft Access INSERT INTO错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ Hi feelas， 请帮忙看看下面我的代码...我使用的是Access2003，错误是由于插入到声明中。你能帮我找出下面的代码有什么问题吗？提前致谢。上帝保佑和更多权力！ Dim dbs As Database Dim cmd As New ADODB.Command Dim strsql As String strsql =INSERT INTO PACRLog [PONumber] VALUES'& PONumbertxt.Text& ' 使用cmd .ActiveConnection = CurrentProject.Connection .CommandText = strsql cmd.Execute End with 解决方案 Hi feelas,Please help be out see my code below...Im using Access2003 and the error is due to insert into statement. Can you help me out find what's wrong with the code below? Thanks in advance. God bless and more power!Dim dbs As Database Dim cmd As New ADODB.Command Dim strsql As Stringstrsql = "INSERT INTO PACRLog[PONumber] VALUES '" & PONumbertxt.Text & "'"With cmd .ActiveConnection = CurrentProject.Connection .CommandText = strsql cmd.ExecuteEnd With 解决方案 这篇关于Microsoft Access INSERT INTO错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！