I have a database that one of the fields is a check box. Basically a
check means yes, no check means no. I am trying to import data from an
Excel spreadsheet. I assumed the check box would use a simple yes/no,
so I set up the Excel SS that way. It will not import the data for
that field. The rest of the fields import fine. How do I do this
please?

Bullfrog

Use a value of -1 for Yes and 0 for No in your EXCEL spreadsheet.

--

Ken Snell
<MS ACCESS MVP>

"Bullfrog" <BullfrogATbullfrogspond.com@> wrote