Introduction

        GenerateXLS is an ASP script that generates a comma delimited (CSV) file (that you can then open in Excel or some similar spreadsheet software) from a database. It is distributed under the GNU Public License.

Requirements & Setup

       GenerateXLS requires that you are running on a machine able to process ASP scripts (either IIS or some webserver with a plug-in that handles ASP).

Installation: Download here and drop it into a directory. 

    You then have to modify the "sDSN" variable to your corresponding ODBC data source. 

    Then modify "sFields" variable with the field names from the database, and the "sTable" variable must be changed to the table name where the data is contained.

Release Date 

   11/29/00 - Version 1.0

   10/25/00 - Not a new version. Somebody had a complaint that the software doesn't create an "official" Excel XLS file. It creates a CSV file that you can open in most spreadsheet programs.

   10/25/00 - Version 1.1 - Here's an update. The same person that had the comment from above was getting a funky error. Here's the problem, it occurs when you open a text or CSV file and the first two characters of the file are the letters ID (uppercase). So I fixed it. The field names up top will be lower case.

Reviews:
  HotScripts.com