DESCRIPTION:
===========
This script will read a tab-delimited text file produced by Microsoft Excel or Access and tabulate them as HTML table inside your own template.

INSTALLATION:
============

activetable.cgi:
1) Change the first line (path to Perl) of the script.
2) Go to the next line of the script. Read the instruction there and modify accordingly.
3) Upload this script to your cgi bin or anywhere outside the cgi-bin if your server's configuration allows that. Chmod to 755. You may also rename the script.

template.htm:
1) Create your own template and place +++ (three plus signs) at the location where you want the script results to be printed. See detailed instruction in the script.

HOW TO CREATE A TAB-DELIMITED TEXT FILE FROM MICROSOFT EXCEL?
============================================================
1) Create your Excel table as usual OR open an existing Excel file (*.xls).
2) Go to "File" on the menu and choose "Save As ...".
3) Name your file.
4) Under "Save as type", choose "Text (Tab Delimited) *.txt".
5) After saving, a warning prompt will appear. Simply ignore it.
* Note: If you have "commas" in the original Excel file, the commas will also appear in the final output. To eliminate these commas, open the saved text file with a text editor such as WordPad and delete all the commas using the "Replace" feature (type a comma in "Find what" and leave "Replace with" empty).
* MS-Access works the similar way.

HOW TO CONVERT THE DATA FILE BACK TO MICROSOFT EXCEL FORMAT?
===========================================================
1) From the "File" menu, choose "Open ...".
2) Change the "Files of type" to "Text Files (*.prn, *.txt, *.csv)".
3) Browse to the text file and open it.

4) A Text Import Wizard will show up. Select the radio button "Delimited"; "Start import at row" as "1" and "File origin" as "Windows (ANSI)". Click NEXT.
5) Mark the "Tab" checkbox. Leave "Text qualifier" as ". Click NEXT.
6) Choose the "Text" radio button. Highlight ALL columns under "Date Preview" by holding down the SHIFT key. Click FINISH.
* MS-Access works the similar way.

HOW TO PLACE A HEADER AT THE FIRST ROW OF THE TABLE
===================================================
While entering the data in Excel, format the header using HTML tags. For example, you may use "Item" in the A1 field, "Description" in the A2 field and so on.

PROBLEMS?
========
Please sent an email to [e-mail] describing
- the problems
- error message generated
- URL to the script and/or result page
- other things that you think might be helpful
* We usually response in less than 12 hours (average is about 4 hours). But before that, you will receive an auto-responded email describing the most common CGI installation mistakes.

The Management,
UPDN Network Sdn Bhd
www.upoint.net
General: [e-mail]
Technical help: [e-mail]