[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.

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.

Thanks very much, Static.