Syntax error in INSERT INTO?

[Danielf]

Hi,


I am trying to insert into table 1 the fields "title" and "size" from table 2. I have tried the following syntax

Set dbs = CurrentDb()
dbs.Execute " INSERT INTO table1 (title,size)" & "SELECT * " & "FROM [table2];"
But nothing happens.

Thanks for help.

Daniel

 

[Guus2005]

Use explicit fieldnames

dbs.Execute "INSERT INTO table1 (title, size) SELECT title, size FROM table2;"

 

[Danielf]

Use explicit fieldnames

dbs.Execute "INSERT INTO table1 (title, size) SELECT title, size FROM table2;"

But the names "Title" and "size" are the name of the fields in my table.

Daniel

 

[Guus2005]

- Yes? -

You have to use explicit fieldnames and not an asterisk (*)

 

[Danielf]

- Yes? -

You have to use explicit fieldnames and not an asterisk (*)

Thanks, it works

Daniel