A
adelkoh
I am trying to import an Excel spreadsheet into a table in Access and I keep
getting the error message "Type Conversion Error". The field causing this, is
of text format in Excel, which is the same as the data type specified in the
table in Access. So what can the problem be due to?
The data I am trying to import is a list of employee IDs, which are numbers
but formatted as text. Within are also some "TBA"s for open headcounts. So
given that the "Text" data type can capture alpha-numeric entries, I cannot
understand why there is an error.
Can someone please help?
Thanks.
getting the error message "Type Conversion Error". The field causing this, is
of text format in Excel, which is the same as the data type specified in the
table in Access. So what can the problem be due to?
The data I am trying to import is a list of employee IDs, which are numbers
but formatted as text. Within are also some "TBA"s for open headcounts. So
given that the "Text" data type can capture alpha-numeric entries, I cannot
understand why there is an error.
Can someone please help?
Thanks.