| | |
|
|
|
Fields in Checkboxes excluded in Analyse It with Microsoft Excel |
|---|
| message from =?Utf-8?B?eWFubg==?= on 13 May 2004 |
I was using the "Analyse It with Microsoft Excel" Function in Access and just realised that all fields that are in checkboxes are excluded in the XL file exported. Is there anyway to include the checkbox fields?
Thanks
yann
|
| Michelle replied to =?Utf-8?B?eWFubg==?= on 18 May 2004 |
I just tried it using Access 2003/Excel 2003 using the Northwind sample
database (open table Products, Analzye it with MS Excel). It brought over
the "Discontinued" field which is a checkbox/ yes/no field, but in Excel the
data changes from a checkbox to TRUE / FALSE.
If you don't get the field at all, let us know which version you're using
and how you're doing it. If you get the field with TRUE/FALSE but want it
to be in checkbox format, you'll need to write code in Excel to handle this.
Michelle
"yann" <yann_nyy@pacific.net.sg> wrote in message
news:CD23B271-7D60-4E5D-B39E-75E483DB028A@microsoft.com...
just realised that all fields that are in checkboxes are excluded in the XL
file exported. Is there anyway to include the checkbox fields?
|
|
Archived message: Fields in Checkboxes excluded in Analyse It with Microsoft Excel (MS Access Error Message)
