Importing multiple check box answers from Excel

[RMEickhoff]

I have an Access database that has one field where multiple check boxes can be selected (i.e.; red, blue, green, yellow, white, orange). I am trying to upload those multiple answers from an excel spreadsheet. Not having much success using TRUE, FALSE, FALSE, TRUE, FALSE, FALSE (as an example. Help!

[zmbd]

REMickhoff
Your title is Excel
Your description is Access.

Second, sounds like you set up a multivalue field:
Guide to Multivalued fields
AVOID THESE LIKE THE PLAGUE!!!!
THERE IS ONE AND ONLY ONE USE FOR THESE, Share Point Applications.

Stop now, and learn about database normalization.
(BTW: MVF are a poor implementation of normalization)
[*]> Database Normalization and Table Structures.

More to say; however, once you get your database normalized and what you want a little clearer we can move on from there:

Gota run...