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

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

 

[Douglas J. Steele]

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.

 

[Guest]

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.

 

[Douglas J. Steele]

How are you exporting the data?