Backing up a table

Results 1 to 3 of 3

Thread: Backing up a table

  1. #1
    Join Date
    Dec 1969

    Default Backing up a table

    Hi,<BR>How do I backup just one table, W/ All the contents? I&#039;ve found tons of stuff on backing up whole databases but I just wana backup one table. Thanks - Trevor

  2. #2
    Join Date
    Dec 1969

    Default What DB?

    With Access, you can do:<BR><BR>SELECT * INTO newTable IN externalDB.mdb FROM anyTable<BR><BR>The external DB must already exist; the table in the external DB must *not* exist. <BR><BR>You can do something similar with SQL Server, but the way to specify the external DB is different, I *believe*.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Backing up a table

    insert into thetableinbackupdatabase IN &#039;c: hebackupdatabase.mdb&#039; Select * From tablebeingbackedup<BR><BR>this is for access

Posting Permissions

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