Import boolean from Excell -- how?

[plh]

Hello,
How would I set up a column in Excel such that when I import it into Access,
Access recognizes it as a Boolean data type? I tried using 1 for yes and 0 for
no, but that came in as double. Should I use -1 for yes, something like that?
The data type control is grayed out when I import. This spreadsheet is not long
yet, so it would not be too much trouble to change the 1s to -1s, or whatever.
How would I format the column on the Excel side? The choices do not seem to
include Boolean.
Thank You,
-plh

 

[Ken Snell \(MVP\)]

Put the words True and False in the EXCEL cells ... ACCESS most likely will
then bring them in as boolean types.

 

[plh]

Worked perfectly, Thank You!
-plh

Put the words True and False in the EXCEL cells ... ACCESS most likely will
then bring them in as boolean types.