Results 1 to 3 of 3

Thread: [RESOLVED] Table Back-Ups

  1. Apr 20th, 2006, 04:08 AM #1
    MethadoneBoy
    MethadoneBoy is offline

    Thread Starter
    Addicted Member MethadoneBoy's Avatar
    Join Date
    Oct 2001
    Location
    Preferably somewhere between Keira Knightley and Diane Kruger but I'm not fussy
    Posts
    180

    Resolved [RESOLVED] Table Back-Ups

    Hi guys,

    We've an Access database that contains some important financial commission information that I'd like to create a back-up job for. Basically there are several tables in that application with crucial information that we cannot afford to lose. My idea was to simply create a macro that will output these tables to a specific directory on our network. Unfortunately, there are too many rows in each of the tables to export to an Excel spreadsheet (we're using Access 97 and don't have the option of migration to a superior version). Is there any practical way of exporting the data in such a way that, should a catastrophic event causing the tables to be deleted or have their contents wiped occur, this data can be easily read back into the tables? I'd be interested to hear if any of you have had similar issues.

    Thanks in advance.
    Last edited by Hack; Apr 20th, 2006 at 08:14 AM. Reason: Added green "resolved" checkmark Last edited by MethadoneBoy : Today at 08:50 AM. Reason: Resolved
    "'Oh, hello Mr. Crick! What do you think of Jeffrey Archer?' Clip-clip-clip! Oh, come on! Who are you kidding? You wait til I'm mayor, you'll see how tough I am! Christ almighty...."
    Reply With Quote Reply With Quote
  2. Apr 20th, 2006, 07:38 AM #2
    Static
    Static is offline
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Table Back-Ups

    Output to a text file.

    take the first few rows, and dump to excel.
    export (save as) a CSV file.

    now import into Access and create an import spec.

    now use Transfertext with the importspec and now u have a nice csv file of your table.
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"
    Reply With Quote Reply With Quote
  3. Apr 20th, 2006, 07:49 AM #3
    MethadoneBoy
    MethadoneBoy is offline

    Thread Starter
    Addicted Member MethadoneBoy's Avatar
    Join Date
    Oct 2001
    Location
    Preferably somewhere between Keira Knightley and Diane Kruger but I'm not fussy
    Posts
    180

    Re: Table Back-Ups

    Thanks very much, Static.
    "'Oh, hello Mr. Crick! What do you think of Jeffrey Archer?' Clip-clip-clip! Oh, come on! Who are you kidding? You wait til I'm mayor, you'll see how tough I am! Christ almighty...."
    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