How To Copy And Paste An Access Table Under A New Name

[John Overton]

I have a need to copy an ACCESS Table and save it as a different named table but with the same table format with VBA.

I am using VBA in ACCESS 2003.

Thanks much for any suggestions.

Sincerely,
John Overton

[tifoso]

Although Access is a bit of toy DB it does some of the basic ANSI sql stuff just run this query in your vba

select * into table_copy from source_table

you may want to turn off the warnings before and after you execute the query

Ciao

[Killer42]

If you need further help with this, I'd suggest you post a question in the Access forum.

(Not that there's anything wrong with posting it here - it's just that I believe you'll find much more Access expertise over there.)