I'm trying to import Excel data and append it to my table in Access 2007. Whenever I try to do this I get an "unparsable record" error. The items that are the problem are all the same field for each record.
A little bit of information about the field... this field is designed in my database to allow me to select multiple number (key) values from another table via a combo box.
My data in Excel is listed out with the multiple key values for this field. e.g. 19, 20, 56.
Any ideas for how to get it to import these fields??? There is way to much information to manually select each value for every record.