I am a very new user and I am importing (appending) excel files into a table in access, but I consistently receive "type conversion failure" import errors and some cells turn up blank as a result. These errors usually occur in cases where there is a "-" between numbers or alphanumeric combinations in fields that are primarily just numbers. I have set every field type as text and they are listed as such in design view, but these errors persist. Does anyone know why these errors occur even when the field type is set to text and what I can do about it?
Thanks!