[AccessD] INSERT Syntax Error

Can you link to the table in the other database and do an insertion using a
LEFT JOIN / unmatched query?



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
>