Move records from one db to another?

OK, im fairly new to all this asp gear, but i was wondering if there was a way to move a set of records from one database into another database??

Basically i want to archive a whole heap of records that i already have in on database.

Im using an access database as well

Even moving them into a nother table would probably do as well

thanks

You can use two connections and read stuff out of one connection database and write it to the 2nd connection database. You'll have to write some code to act as the middleman.

would it be easier to just write all the stuff to another database.. then go back to the original and delete the stuff that was just copied?

Can access not just copy tables or select from one table into another directly from SQL?!?!?!?!

or if it's a complete copy why not copy the .mdf file?

i dont quite get what youre saying.. i want to move all the records in table1 that match "xyz" into table2

If your .mdb files are local, you could move data by linking tables or importing between the two db's within Access. This probably won't be an option with a hosted asp server where you can't open your database in Access itself.