从MS Access 2007导出到Excel
问题描述：
你好，
我正在从Access导出到Excel中的表.该表包含一些位字段，在导出到Excel时，我希望保留这些字段作为复选框.当我运行导出时，位字段将转换为TRUE或FALSE.任何帮助将不胜感激.
Hello,
I am exporting a table from Access to Excel. The table contains bit fields that I would like to retain as checkboxes on the export to Excel. When I run the export the bit fields are converted to TRUE or FALSE. Any help would be greatly appreciated.
答
使用标准Access 2007方法，您不能将位字段导出为复选框.复选框可以具有双重或三重状态.如果只有true或false值，则表示:true(-1)= checked，false(0)= unchecked.
Using standard Access 2007 methods, you can''t export a bit fields as checkboxes. Checkboxes can have double or triple states. If you have only true or false values, it mean: true(-1)=checked, false(0)=unchecked.