[AccessD] INSERT Syntax Error

Dear List:
 
Trying to append all records in a table to a table in a second database, the
following gives me 'syntax error in INSERT INTO' statement.
 
db1.Execute "INSERT INTO tblProductStructure in " & Me.txtTargetDatabase & "
SELECT tblBOMReport* from tblBOMReport"

where me.txtTargetDatabase has the full path and file name of the target and
tblBOMReport has the same structure as tblProductStructure. and db1 is set
to CurrentDb.
 
What am I doing wrong?
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> 
www.e-z-mrp.com <http://www.e-z-mrp.com/>