Re-import of TmpV2 data from Julie's Export 2014-09-08

Original import of TmpV2 went wrong. Julie provided a new export 2014-09-04.

Files are in X:\CCMDB\TmpV2_final

steps

1. copied backup of centralized_data.mdb to files as centralized_data_pre_tmpv2_import.mdb
2. copied centralized_data.mdb to desktop
3. ran
   • SELECT L_TmpV2.D_ID FROM L_Log INNER JOIN L_TmpV2 ON L_Log.D_ID = L_TmpV2.D_ID WHERE (((L_Log.RecordStatus)<>"incomplete"));
   • deleted the 120274 records in that query
4. converted Julie's .xlsx file to something Access 2003 can read: .csv
   • confirmed 259802 lines one less record in both
5. imported into table
   • imported dates and serial as text because Access had errors otherwise (256401 has loong comment)