Batch update analysis fields on sales orders

Hi,

I need to update one of the analysis fields on many sales orders in Sage 50 Accounts Professional. These are highly repetitive and the task of inputting them manually would be inefficient. Since there is no way to do this through the interface, can I achieve this in any other way? Can I get help with accessing and writing to the database directly and amending those records?

Thank you