ACCESS ="NO" BUT EXCEL DISPLAYS "0"
 

Intermittently when I export a query from Access to Excel, a "NO" in one of
the text fields in Access (contains YES, NO, and N/A) seems to get changed to
a "0" (zero) in Excel.

Is there any way to prohibit Excel from changing the NO to 0 ?

Doesn't Excel take its cell format from what's being imported?

ACCESS ="NO" BUT EXCEL DISPLAYS "0"
 

Hi,

Check your table design in Access and make sure it is not a Boolean data
type, but is Text.

If this does not work, please tell us how you are getting the data from
Access to Excel.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pauld" wrote:

Intermittently when I export a query from Access to Excel, a "NO" in one of
the text fields in Access (contains YES, NO, and N/A) seems to get changed to
a "0" (zero) in Excel.

Is there any way to prohibit Excel from changing the NO to 0 ?

Doesn't Excel take its cell format from what's being imported?

ACCESS ="NO" BUT EXCEL DISPLAYS "0"
 

The Access table field is definitely a Text field.

I'm using the "Output" macro to output a query that contains this field to
Excel.

The text in the table is definitely NO, and the query also shows it as a NO.

But the NO sometimes gets changed to a "zero" in Excel.

Seems like Excel should accept a text field and treat it as a text field.

Thanks

"Shane Devenshire" wrote:

Hi,

Check your table design in Access and make sure it is not a Boolean data
type, but is Text.

If this does not work, please tell us how you are getting the data from
Access to Excel.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pauld" wrote:

Intermittently when I export a query from Access to Excel, a "NO" in one of
the text fields in Access (contains YES, NO, and N/A) seems to get changed to
a "0" (zero) in Excel.

Is there any way to prohibit Excel from changing the NO to 0 ?

Doesn't Excel take its cell format from what's being imported?