Insert statement using Select *
Posted on 2009-04-20
Not sure why this is getting me stuck but it is.
I have a pivot query in access that obvisouly creates columns based on the pivot, hence the column names can change. So I was trying to insert the contents of the pivot query into a table like so.
INSERT INTO tbl_output ( Column1, column2, column3, column4, column5)
SELECT * FROM qry_pivot
However I keep getting the error
"The INSERT INTO statement contains the following unknown field name: 'sAge_item'. Make sure you have typed the name correctly, and try the operation again.