I would have thought trying to enter invalid values would generate "The value you entered is not valid for...".
My guess is that the first table contains at least one null in at least one record (there is no value). You can get that error during this operation or when you attempt to use a conversion function on null.
You would have to enter a value that you can remove after the table is made. If the fields are text I think you could convert all nulls to empty strings, make the table and then convert back to null.
Last edited by Micron; 08-24-2019 at 08:05 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.