Using SQL statement to add a query to table

Question

I am trying to add a query result to a table in MS Access 2010 by running a SQL statement, but I get a time-run error saying

Microsoft Access can not find the input table or query. make sure it exists and the name is spelled correctly.

This is my code, please help me to check where I am wrong.

Private Sub Command6_Click()

    Dim strSql As String
    strSql = "INSERT INTO test(ConsumedDate, FinishedProudct, ConsumedItem, ConsumptionQuantity, Unit), SELECT ProductDate, ProductCode, [Ingredient/Packaging material],Consumption, FROM FormulaQuery"
   CurrentDb.Execute (strSql)

End Sub

Another question, can I use a datasheet form as input source in such condition?

Thanks

Jiangzhou

Ciro Corvino · Accepted Answer · 2016-06-08 21:06:25Z

2

...,Consumption, FROM FormulaQuery"

there is some comma in plus ;)

answered Jun 8, 2016 at 21:06

Ciro Corvino

2,1466 gold badges23 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using SQL statement to add a query to table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related