Copying table contents from one table to another using filter?

[shabbaranks]

Hi all,



I have two tables one is linked to a spreadsheet and the other isnt. What I am trying to do is import the table's data which is linked to the spreadsheet to the table that isnt linked but only import the fields which contain perticular content in a column.

Can anyone shed some light on how I achieve this please?

Thanks
Shabba!!

[hertfordkc]

use an update query to get the fields which you need.

[shabbaranks]

So Ive created a query on the linked table to show the criteria Im after - how do I then get that across to my other table?

Thanks

[hertfordkc]

So Ive created a query on the linked table to show the criteria Im after - how do I then get that across to my other table?

Thanks

If you have a query that is giving you the info that you want to append into the other table, then, in design view (Access 2007) you can convert a Select query to an Update query.

[shabbaranks]

Im not sure I want to append the data though - as wouldnt this give me duplicates? I would only want to add data which isnt on the table already.

[hertfordkc]

Im not sure I want to append the data though - as wouldnt this give me duplicates? I would only want to add data which isnt on the table already.

either before or after the update. You might set up a macro to handle this.