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