Results 1 to 2 of 2

Thread: SQL To Copy a Table

  1. Apr 2nd, 2002, 10:51 AM #1
    Chick
    Chick is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2000
    Posts
    66

    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
    Reply With Quote Reply With Quote
  2. Apr 2nd, 2002, 10:54 AM #2
    Geoff Gunson
    Geoff Gunson is offline
    Addicted Member Geoff Gunson's Avatar
    Join Date
    Jun 1999
    Posts
    241
    Hi

    select * into Bob from simmsnos

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

    HTH

    G
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width