How to Copy or Import 'selected fields' from one table to another?

's Computer Specifications

We have two tables... tblOld and tblNew... both in the same data base

we want to copy or Import certain fields in tblOld to selected records in
tblNew

the records in tblNew are already created and a couple of fields are already
populated properly

we want to...
- select a set of records in tblNew
- select a set of records in tblOld
- select the fields in tblOld we want to copy or import into tblNew
- the field names in both tables are the same

Thanks for any help on how to do this.

's Computer Specifications

On Nov 1, 5:35 pm, "Will" <W...@somewhere.com> wrote:
> We have two tables... tblOld and tblNew... both in the same data base
>
> we want to copy or Import certain fields in tblOld to selected records in
> tblNew
>
> the records in tblNew are already created and a couple of fields are already
> populated properly
>
> we want to...
> - select a set of records in tblNew
> - select a set of records in tblOld
> - select the fields in tblOld we want to copy or import into tblNew
> - the field names in both tables are the same
>
> Thanks for any help on how to do this.

join the tables and create an update query.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import excel but selected column for selected table	EMILYTAN via AccessMonster.com	Microsoft Access Form Coding	4	15th May 2007 03:27 AM
User Selected File won't import into table	TexasStar	Microsoft Access VBA Modules	6	19th Apr 2007 05:50 PM
Import automation, selected mdb fields from server to Excel	=?Utf-8?B?amFtZXM=?=	Microsoft Excel Programming	0	18th Nov 2005 10:40 PM
Need to copy information between fields when checkbox is selected	=?Utf-8?B?U3RhY2V5Sg==?=	Microsoft Access Forms	1	29th Dec 2004 05:49 PM
Fields vanish when Replicate selected for table!	=?Utf-8?B?Smlt?=	Microsoft Access	0	21st May 2004 02:56 AM