[AccessD] INSERT Syntax Error

Rocky Smolin rockysmolin at bchacc.com
Thu Nov 10 14:06:44 CST 2011


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/> 
 



More information about the AccessD mailing list