Report Offensive Message

The biggest problem with importing to ACCESS from EXCEL is where the column has a mixture of numeric values and alphanumeric texts. If the first 25 rows has numeric values, then ACCESS treats this column as numeric field. Then if subsequent rows has alpha text, these values will be ignored. I get around this by creating a new column and use the TEXT function to assure all values are treated as text.