[AccessD] Copy Record from one db to another

Any spaces in the target database's  path?

-- 
Stuart

On 10 Nov 2011 at 12:18, Rocky Smolin wrote:

> I will delete from the target db all the records in the source that match
> up. 
> 
> But that still leaves me with the copy (or append actually) which I was
> trying to do with an INSERT INTO statement but can't seem to get the right
> syntax.  I have the target db path and name available in a text box.
> 
> But this is not working:
> 
> db1.Execute "INSERT INTO tblProductStructure.* in " & Me.txtTargetDatabase &
> " SELECT tblBOMReport.* from tblBOMReport"
> 
> At this point I'll have deleted all the records from the target that match
> the source so the source records can all be appended in one swell foop.
> 
> R
> 
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
> Sent: Thursday, November 10, 2011 12:10 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Copy Record from one db to another
> 
> When you say "COPY", does that mean all target records with matching keys
> from the source are deleted and then inserted ?
> Or is it a mixed bag where some new ones are inserted and some existing ones
> updated ?
> 
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com [mailto:accessd- 
> > bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> > Sent: Thursday, November 10, 2011 2:22 PM
> > To: 'Access Developers discussion and problem solving'
> > Subject: [AccessD] Copy Record from one db to another
> >
> > Dear List:
> >
> > I need to copy specific records with about 35-40 fields per record 
> > from one database to another.  No autonumber PK.  Are there any slick 
> > tricks for doing this?  I have the path and file name of the target 
> > and the table will be present there.  The source db is CurrentDb.
> >
> > 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>