ACCESS ="NO" BUT EXCEL DISPLAYS "0"

  • Thread starter Thread starter pauld
  • Start date Start date
P

pauld

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?
 
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.
 
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
 
Back
Top