SQL To Copy a Table

What is a good way to make a copy of an Access table from VB within the same database (just copy and rename)?

Thanks

Hi

select * into Bob from simmsnos

Where Bob is the new table name and simmsnos is the existing table

HTH

G