How can I output a yes/no field from Access 97 database to Excel?

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

Guest

I have been able to successfully output the database except the yes/no fields
that have a check mark in Access 97. Is there a way to do it in 97 and in
2003?

Thanks a lot!

Jose.
 
What happens when you try? Even if it's displaying in Access as a checkbox,
the underlying field contains either -1 for True or 0 for False. That should
be what you see in Excel.
 
The output I am getting in the Excel file is blank fields instead of the -1
and 0. I have double checked to make sure that the fields are checked in the
Access database and they are. Why?

Thanks Douglas.

Jose.
 
Back
Top