[AccessD] INSERT Syntax Error

That would be second easiest solution - after  a simple SQL statement. :) 

Guess I'll go that way next.

Tks.

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, November 10, 2011 12:20 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com