Access to HTML

From Sfvlug

I have written a bash script that converts Access databases to HTML. Source Code

I know of at least two people in the LUG who were interested in this functionality. Code is GPL.

#!/bin/sh

# This script converts Microsoft Accesss files to HTML
# It requires the following tools:

# mdbtools (http://mdbtools.sf.net)
# csv2html (http://joncombe.future.easyspace.com)

FILE=$1
TABLES=`mdb-tables $FILE`

HEADER_COLOR=green
CELL_COLOR=FFFFFF
TITLE="HTML Conversion of $FILE"

mdb-export $FILE $TABLES | csv2html -o $FILE.html -t "HTML Conversion of $FILE"  -h $HEADER_COLOR -b $CELL_COLOR