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 Copyrighted  2000, Brain Scan Studios, Inc. and is distributed under the GNU Public License.

Features

• Generates a comma delimited (CSV) file (that you can then open in Excel or some similar spreadsheet software) file from database data.
• Written in ASP (easy 2 modify)
  

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: Cut and paste the script 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). Here's the official Microsoft link. So I fixed it. The fields up top will be lower case (cause the Microsoft fix was kinda dumb, it added an apostrophe "'" to the beginning of the file).