从MS Access 2007导出到Excel [英] Export from MS Access 2007 to 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.

这篇关于从MS Access 2007导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！