I've got some data (basic personal details) which I need to export from an old legacy system to a newer system (MySQL DB). It's approximately 200MB split across 6 files.
The system I'm exporting from can export all the required data as an Excel file. However it's method of creating an Excel is to create a HTML table and save it with a
.xls extension. When viewed in a text editor they just look like this (except 600,000 lines long).
<table> <tr> <td class="tableh"> <b>Birth Date</b> </td> <td class="tableh"> <b>First Name</b> </td>
Much to my surprise Excel can actually open such a document. Unfortunately it takes about half an hour to do so (per file), and almost as long to save it into a proper format.
Does anyone have any suggestions for converting these (faster than the 45-60mins it takes Excel)?