[AccessD] INSERT Syntax Error

Rocky,
If this is the sql you are using, you need a period here tblBOMReport.*
(between the tablename and the asterix.
jack

On Thu, Nov 10, 2011 at 4:34 PM, Charlotte Foust
<charlotte.foust at gmail.com>wrote:

> 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
> >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>