Dualdflipflop at 06:02, 29 January 2007

Dualdflipflop — Mon, 29 Jan 2007 06:02:00 GMT

New page

I have written a bash script that converts Access databases to HTML.
[http://thewybles.com/~charles/me/code/mdb2html.sh.txt 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

Access to HTML - Revision history

Dualdflipflop at 06:02, 29 January 2007