Backup a database (only certain records)with certain criteria satsifed

[sunilvedula]

Hi all,

I am trying to backup a database from a two tables where the unique key is UDFNum and should backup the records from the tables where the status is "c". i dont want the entire tables to be backedup but specific records through a macro. i also have a query built which gives me the list of records which have status "C". Is there any way to do them.