Oh Ok David,

I didn't know it was possible, now I know.

It's good. I learn things by helping people.

I don't think you can insert rows into a linked server using openquery statement.

If linked servers are RDBMS as SQL Server, MS Access Oracle or else, you can insert row by referencing...

Your demand is not very clear but according to what I understand.

You must retrieve data you need.

For example

testkey cDate count(*)

12345 2006-01-01 5

54321 ...

I think the best way is to use a DTS package. When you create a new package, you can choose a task called "dataBase transfer task" (I don't know the...