Can't convert Variant of type 8 to desired type 14
Can't convert Variant of type 8 to desired type 14

I've run into this error message a couple of times now, and each time it has taken me far too long to correct it.

In the end, the problem lies in data that is copied from one source to another, usually from Excel into Access, and the error doesn't show up in every field, nor is it something you can see. Generally, the solution is to delete the offending data and re-key it manually.

Archives