This one is not quite as easy as the title suggests. I'm a fairly experienced RHCE admin with mysql skills and so far it's beaten me.
I have a typo3 cms with a modified news extension. The data appears as here [url removed, login to view]
I need to load in from 9 word docs about 250 rows consisting of about 60 colums. Of that I guess 25-30 columns will contain non default data. The reason why it's word docs and not spreadsheet is because the docs contain an image which in the database will be represented as an image id
To make things easier there is a phpmyadmin interface. Copying an existing row and attempting to insert shows the required sql query needed. Unfortunately a straight copy returns an error about a null value.
The work then is
* Fixing the error about "field cannot contain a Null value" (I've checked the data and it is non null)
* Converting table docs to csv format
* Loading the data - 250 rows
If you know typo3 and mysql that would be perfect