Importing Yes/No from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that I am importing from Excel that contains 5 columns
of Yes/No imformation.

When I import it into access the Yes/Nos are converted to -1 and 0. However
I want people to access the table with check boxes, like are created when I
make the table in Access.

Anyone know why the data is not converted to appear the same as if I create
the table?
 
Are you importing to an existing table? If yes, make sure that the datatype
for that yes/no field is Yes/No (boolean).

Are you importing to a new table? If yes, after doing the import, go into
the table's design view and change the yes/no field's Data Type to Yes/No.
 
No. I am creating a new table. I tried importing from Excel and from a text
file where I got to choose the y/n data type. I still get -1/0 when I import.
--
Thanks As Always
Rip


Ken Snell (MVP) said:
Are you importing to an existing table? If yes, make sure that the datatype
for that yes/no field is Yes/No (boolean).

Are you importing to a new table? If yes, after doing the import, go into
the table's design view and change the yes/no field's Data Type to Yes/No.
Click to expand...
 
-1 is True (Yes) in an ACCESS database; 0 is False (No). That is how the
data are stored.

ACCESS will display a "checkbox" if you set the "Lookup" property for the
field (design view of the table) to "Check Box".

--

Ken Snell
<MS ACCESS MVP>


Ripper said:
No. I am creating a new table. I tried importing from Excel and from a
text
file where I got to choose the y/n data type. I still get -1/0 when I
import.
Click to expand...
 
Thanks Ken. Worked like a charm. I made the table in Access and then
imported into it and the check marks showed. I knew then that it was not an
import hing, but an Access thing.

You saved me a ton of time looking for it though.
 
Back
Top