ADO, copy table

[Rabold]

I want to copy a recordset with ADO in order to keep a backup copy of the table (I don't want to know its structure)
How can I do this using ADO.

After creating a virtual recordset (creating the structute and filling it with data), how can I connect/Save this object to a physcal table in a database.

Is it possible to copy the structure of a table .

Ideas and informations are welcome. The ADO Programmers Reference book seems to omit all this questions or does hide them from me.

AR

[Johnny101]

One question: why not use a "SELECT * INTO FROM " to create the backup of the table?

if that's no good, what about using ADOX to duplicate the structure and then an INSERT INTO SELECT * FROM to move the data?

just a couple of thoughts,

John

John Pirkey
MCSD
http://www.ShallowWaterSystems.com
http://www.stlvbug.org