S ICD10 table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 47: | Line 47: | ||
Then: | Then: | ||
Import the file into a new table. Importing straight into s_icd10 is possible, but if there are errors it is hard to troubleshoot. Importing into new table first has fewer restrictions. | |||
* In CCMDB.mdb, External Data,text file | * In CCMDB.mdb, External Data,text file | ||
* | * insert into new table | ||
* delimited; click advanced button, make sure field delimiter is ; | * delimited; click advanced button, make sure field delimiter is ;, | ||
* file has headers | |||
Copy content into s_icd10 | |||
* empty out s_icd10 | |||
* copy and paste data from new table | |||
Likely problems | |||
* bad data in a column | |||
* duplicate ICD10 codes due to evil twins on wiki | |||
== Related Articles == | == Related Articles == | ||