Import boolean from Excell -- how?

  • Thread starter Thread starter plh
  • Start date Start date
P

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
 
Put the words True and False in the EXCEL cells ... ACCESS most likely will
then bring them in as boolean types.
 
Back
Top