in access i am doing this:
insert into accounts_changes
(select *
from accounts
where [Agency Code]
in (select * from tableimport))
it says that it doesnt like this INSERT statement
update:
sSql = "insert into accounts_changes (select * from Accounts where [Agency Code] in (select [Agency Code] from tableimport))"
i did what mark said and it is still giving me the same error message
syntax error in INSERT INTO statement
when i do this:
ssql = "select [Agency Code] from tableimport"
CurrentDb.Execute ssql
it says CANNOT EXECUTE SELECT QUERY