title: Unparsable error when importing excel data to Microsoft Access
body: <p>Working on importing data from an excel file into Microsoft Access (2007-2010), the import has gone smoothly, being able to properly have the appropriate check boxes checked or unchecked and other fields that has no discrete data populating as they should. </p>
  
  <p>However, in the Access data base, we have a few columns that are from pick lists (a table referring to another table for what options are available), to limit the options to those filling out a form. A few of the pick lists are single select while others are multi-select. When the import runs, for those that have pick lists, an error of “Unparsable Record” occurs for those columns and no data is entered. This error occurs even if the employer is a perfect match to one of the options. As a result, manual entry has to be done. Is there a work around to this error while not changing the pick lists or how the form is configured?</p>
  
  <p>I found this, but hope there is something that can be done to solve this issue to save some very tedious manual data entry. <a href="https://community.spiceworks.com/topic/287861-getting-unparsable-record-when-importing-to-access-2010" rel="nofollow">https://community.spiceworks.com/topic/287861-getting-unparsable-record-when-importing-to-access-2010</a></p>