query syntax,

[fluppe]

Hi everybody,

i have a problem trying something ...
It is the following SQL i want to execute from VBA:

SELECT tbl_Tmp_Conditions.ID, tbl_Tmp_Conditions.ConditionName
 INTO tbl_Conditions.ConditionID, ConditionName 
FROM tbl_Tmp_Conditions  
WHERE tbl_Tmp_Conditions.check = Yes

It is my effort set entries into a table that are copies of entries from another table. But i do not want to copy the whole record, only two fields.
I'm not sure if that can work in this way.
However, something is wrong with this SQL code:

Run Time Error : -2147467259 (80004005)
Query input must contain at least one table


I don't know whats wrong however and i would greatly appreciate any hints. Maybe it is the way i try to run this query ?


Thanks for reading this post,

....

[fluppe]

Ok, i got the first flaw i think ... it is not possible to specify the fields of the target table, right ?
Well then, does the target table have to be empty ?

[fluppe]

OK, it works with

SELECT tbl_Tmp_Conditions.ID, tbl_Tmp_Conditions.ConditionName
 INTO tbl_Conditions
FROM tbl_Tmp_Conditions  
WHERE tbl_Tmp_Conditions.check = Yes

if tbl_Conditions does not exist. That is a problem however, because I'd like to have an existing table ...
Is it possible by means of SQL to add records to an existing table in which the content (as described above) from another table is copied ?

Kind Regards,

....

[June7]

Use INSERT INTO SELECT

http://www.w3schools.com/sql/sql_insert_into_select.asp

[fluppe]

Hello,
Found (nearly) that in the Doc:

"INSERT INTO  tbl_Conditions (ConditionNumber, ConditionName) SELECT  tbl_Tmp_Conditions.ID, tbl_Tmp_Conditions.ConditionName FROM  tbl_Tmp_Conditions WHERE tbl_Tmp_Conditions.check = Yes"

Thanks a lot for your help .... i'm looking for the solved button once more.

Yours,

...