Charlotte Foust
charlotte.foust at gmail.com
Thu Nov 10 15:34:17 CST 2011
Does the tblProductStructure already exist? If so, you would have to append records rather than inserting the table. Charlotte Foust On Thu, Nov 10, 2011 at 12:06 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > 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/ > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > >