If you have static data tables then consider the following option – for low volume static data.
You can set up a DTS package to export the tables to an excel workbook very easily. Just use the export wizard and schedule the DTS package to run at a convenient time.
ODBC drivers are configured on the server – 2000 installed by default but not SQL server 7
The sql server agent account has permissions to write to the folder for the spreadsheet.
That the option to delete the data first is set.
Don’t forget to set up a DTS import package and….test, retest and test again.