Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
INSERT INTO tablename gives error
I have two out of five of my tables in a MS Access database not allowing an INSERT INTO statement. It gives me the error:
The Insert Into statement contains the following unknown field name: CurrMonthName.
My SQL statement goes something like this:
"Insert Into DataTable (CurrMonthName,CurrYear) Values (@CurrMonthName,@CurrYear)
I've tried deleting the table and re-creating it. I removed the CurrMonthName field in the statement so it's just asking for CurrYear, and I still get the same error, except of course it says the unknown field name = CurrYear. I've also tried inserting the data directly from an Append Query in MS Access, and that won't work either.
Any ideas of what I'm doing wrong?
The Insert Into statement contains the following unknown field name: CurrMonthName.
My SQL statement goes something like this:
"Insert Into DataTable (CurrMonthName,CurrYear) Values (@CurrMonthName,@CurrYear)
I've tried deleting the table and re-creating it. I removed the CurrMonthName field in the statement so it's just asking for CurrYear, and I still get the same error, except of course it says the unknown field name = CurrYear. I've also tried inserting the data directly from an Append Query in MS Access, and that won't work either.
Any ideas of what I'm doing wrong?
Asked:
Who is Participating?
Here is the general syntax:
INSERT INTO Table2 ( FIELD1, FIELD2 )
SELECT Table1.FIELD1, Table1.FIELD2
FROM Table1;
Not sure about you @ symbols ...
mx
INSERT INTO Table2 ( FIELD1, FIELD2 )
SELECT Table1.FIELD1, Table1.FIELD2
FROM Table1;
Not sure about you @ symbols ...
mx
This is my code, and it works for my other forms:
I will try the code you posted, and get back to you. Thank you!
I will try the code you posted, and get back to you. Thank you!
str = "INSERT INTO DataTraffic " & _
"(CurrMonthName,CurrYear,StoreName,Traffic) " & _
"VALUES (" & _
"@CurrMonthName,@CurrYear,@StoreName,@Traffic)"
myCommand = New OleDbCommand(str, myConnection)
myCommand.Parameters.AddWithValue("@CurrMonthName", obj3.CurrMonthName)
myCommand.Parameters.AddWithValue("@CurrYear", obj3.CurrYear)
myCommand.Parameters.AddWithValue("@StoreName", obj3.StoreName)
myCommand.Parameters.AddWithValue("@Traffic", obj3.Traffic)
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
To run your Insert statement, just issue it directly:
sSQL = "Insert Into DataTable (CurrMonthName,CurrYear) Values ('" & obj3.CurrMonthName & "','" & obj3.CurrYear & "')"
YourConnection.Execute sSQL
If CurrYear is Numeric, you don't need the single quotes around those values.