I'm receiving my data from an outside source via an Excel spreadsheet. My application links to the spreadsheet and copies the pertinent data to the fields I need it in. The problem is with one field (serial number). I have it formatted as a text field and it is also formatted as a text field in the spreadsheet. The majority of the entries are numeric but there are several that are alphanumeric. However, no matter what I do with it, Access will only copy the fields that are numeric. The rest are left blank in the database. What, if anything, can I do to make Access recognize this data and copy it to the table?