remove old data from database

[Shirley Chen]

Dear all:
I am new in SQL script, and I have question for SQL script. I am trying to remove the old record from a specific table and store the old record into a file. Does any one know how to retrieve the record from table and store into a file? (like back up the record) How does the old record re-load back to the table from that file?
Any suggestion is appreciated.

Shirley

[al]

what is the database you are using?

Oracle, Sybase, MSSQL, Access, mySQL, etc...

------------
Shirley Chen at 5/24/01 1:11:46 PM


Dear all:
I am new in SQL script, and I have question for SQL script. I am trying to remove the old record from a specific table and store the old record into a file. Does any one know how to retrieve the record from table and store into a file? (like back up the record) How does the old record re-load back to the table from that file?
Any suggestion is appreciated.

Shirley