I have an access database that needs to be converted to text.
text format
GUID:{00000001-0000-0000-0100-000000000000}
CLASSCODE:8200
LAT:39.296011794358492
LON:-1.467390451580286
Scale minimum:10000000
Category of mariners' note:0
Local time:14.05.2012 15:07
Users' remark:this is a test
GUID: [hex number derrived from the table ID] is 001 = {00000001-0000-0000-0100-000000000000}
'note only the 1st block of the number changes and is a hex value
CLASSCODE:8200 [this is always the same]
LAT: [gained from the Latitude columb no conversion'
Long:[gained from the Longitude columb no conversion'
Scale minimum:[gained from the scalemin columb]
Category of mariners' note: [gained from the catagory columb]
Local time:[gained from the edit date columb if none stored use system date [uk date format]
Users' remark: [gained from the description columb]
we would be happy with a command line application that will convert a specified input .mdb file into the same name output file and asap