Thank you for responding. I have tried this, the main problem was the date format. SHINE needs the data format to be yyyy-mm-dd hh:nn:ss (ISO 8601 extended format) and the CSV export puts it into another format (“16/02/2011 10:05:00”). It also puts in the MI_PRINX data even though that is hidden in the table in Earthlight, and also the field names at the top of the CSV. The extra field may not be a problem, but the field names can’t be in there.
If there is some way of formatting date fields in Earthlight that I have missed please let me know.
I know it is relatively simple to remove the field name line from the top, but this really needs to be as simple as File, Save copy in MapInfo that we currently use, so I have written the Export to run straight from SQL via a button in our HER database, I just have no way of testing this and wondered if anyone else used the CSV method of uploading to check that the format is correct before I attempt a load on the live system.