In case folk are still wondering how to get an NIV translation into OpenLP, I've managed it.<br>1. I found an NIV download in XML format (US language, so translated the US spellings to UK).<br>2. Exported the XML into the tab-separated fields used in the SQlite database OpenLP uses (fields: 'id','book_id','chapter','verse','text'), prefixing the (verse) 'text' field with "'$" (<single-quote><dollar>).<br>[Note: 'id' is a sequentially numbered value from 1 to 31102]<br>3. Imported the tab-separated data into Excel (the "'$" stops Excel interpreting double-quotes in the text field, so preventing it joining multiple records trying to find the corresponding close double-quote).<br>4. Global search+replace of "'$" with <blank> (to delete the "'$")<br>5. Copy the RSV.sqlite file to NIV.sqlite<br>6. Create an ODBC connection to NIV.sqlite, then open in Access (connecting to the data file, not importing it).<br>7. Delete all rows in the 'verse' table.<br>8. Copy all rows from Excel and paste into 'verse' table in Access (will take quite a few minutes, as there are 31,102 verse records).<br>9. Update the 'name' and 'copyright' fields in the metadata table.<br>Done.