Scripting: Access file with 3 columns [solved]

[Darkelve]

I've got a table in Access and have to publish the data on our website. I converted it to PDF, but our website also has to be accessible for visually impaired people. So I need to make Html tables as well.

 

The access file is very simple and has 3 colums A, B and C.

 

I would like to find a way to script it so that this structure is reached for each row:

 

<tr>
<td class="tdemright">Column A</td>
<td>Column B</td>
<td>Column C</td>
</tr>

 

There are 5 'worksheets' in the access file. Manually this would take an awful long time. But since there is a method in this, with scripting it should not be too difficult.

 

Can anyone help me with this?

 

I have uploaded the file for your reference, in OpenOffice Calc format here:

http://www.ducaet.be/nieuwe_lijnnummers.sxc

 

Many thanks!

 

 

Darkelve

[aru]

You don't need a script here, just open that file with gnumeric and select HTML from "File -> Save as..."

[Darkelve]

You don't need a script here, just open that file with gnumeric and select HTML from  "File -> Save as..."

<{POST_SNAPBACK}>

 

Thanks, you're a life-saver! It even has the option of exporting the data as Xhtml!! B)

 

Now only to get rid of the extra attributes. But I think a Search&Replace will do the trick.

 

 

Many thanks!