Importing data to a Check Box from Excel

[Bullfrog]

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

[storrboy]

On Feb 13, 6:40 pm, Bullfrog <BullfrogATbullfrogspond.com@wrote:

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

If you are talking about a checkbox in Excel and not a cell value,
then you need to get the checkbox value into a cell in the
spreadsheet. Access doesn't include user controls in an import. In the
control format properties, I think on the control tab, there should be
a Cell Link box. Enter the cell the checkbox should update. It will do
using a True/False value. When you import the spread sheet, Access
should recognize it as a Yes/No value and import them as 0's and -1's.

[Thats Me]

In the Excel spreadsheet change the yes's to TRUE and the no's to
FALSE

On Tue, 13 Feb 2007 23:40:38 +0000, Bullfrog
<BullfrogATbullfrogspond.com@wrote:

>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

Have a nice day. ld****@NOPANTS.juno.com

Remove NOPANTS. To reply by direct E-Mail;
Support: The Right to Privacy and Anti-SPAM projects

[Bullfrog]

On Tue, 13 Feb 2007 21:52:47 -0500, Thats Me <yq****@whab.pbzwrote:

>In the Excel spreadsheet change the yes's to TRUE and the no's to
FALSE

On Tue, 13 Feb 2007 23:40:38 +0000, Bullfrog
<BullfrogATbullfrogspond.com@wrote:

>>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

Have a nice day. ld****@NOPANTS.juno.com

Remove NOPANTS. To reply by direct E-Mail;
Support: The Right to Privacy and Anti-SPAM projects

DUH, I should of thought of that, TRUE and FALSE worked! Thanks