I'd probably set a filter or sort to get the new items  I need to
copy, then use datasheet view to copy  the cells and paste them into
the same list  on the new server  when it is also in datasheet view.
The major thing I've found is that the fields have to be identical
or else you can screw up your records.

I did this yesterday, and I made sure both views were identical,
then switched to "edit in datasheet" and highlighted and copied the
cells I needed. I suppose you could also select the entire rows, but
I didn't do that. I then switched to the new list and clicked inside
the first cell of the last row (the empty one) and pasted. It
plopped everything into the proper place.

Formatting might be an issue for certain types of columns. Mine were
pretty simple ones, so I didn't run into any snags.

Quick note: Something I recently  discovered is that you cannot edit
in datasheet (it becomes read-only) *if* you have content approval
required for the list. I needed to switch this back to off (after
making sure nothing was waiting for approval) so I could use the
edit in datasheet feature.

Alas, while WSS v3 can migrate content, but 2003 required a manual
effort (copy each listitem by hand, move the entire modified list  using
an STP, etc.) or a custom program.

copying list  items in spreadsheet
is fine. But i guess i missed to mention something. List doesn't
allow me to enter the original user's name in the Created by column
and it says ReadOnly. Think i am violating the security.
Simply saying, we have a bulletin board running in sharepoint and
ppl use to post there items  to the list. Do you guys think that i
can copy  the Created by column and paste it to the new list?
Sharepoint ain't allowing me :D.

Todd()
{
return answerpls;
}

'There is a way, if there is a will'

The Created By column is not only ReadOnly, it can't even be manipulated
by the Object Model. There are some third party tools that let you
specify it but I think that they all update the database directly.

If you're uploading from the api it's one of the parameters. I rarely
use anythingother than administrator because matching user names isn't that fun,
but it's possible... At least on creation.