Importing records into table

[Spricar]

Hello all!

I've got a problem I can don't know how to solve (since I'm a complete access noob). I've got an acces table that is populated with around 1000 entires, all starting with letter N, followed by numbers. Then I've got another table from last year which is also populated with 1000+ N entries AND 1000 V entries.

I would like to trasnfer/copy all V entires from last year table into this year table. I'm sure this is possible but I don't know how. In short, I would like to copy 1000 rows of last year data into this year table/data. What's the easiest way (if there is any)?

Thanks for all your help in advance

 

[JHB]

What about an Update query?

 

[Spricar]

What is an update query?

 

[pwbrown]

Use an append query not an update query. In the criteria of the column you want to start with v insert : Like 'v*'
This will select all records where the column data starts with v and anything else after the v.