ACCESS ="NO" BUT EXCEL DISPLAYS "0"

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?
 
S

Shane Devenshire

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.
 
P

pauld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Cell Reference Shows "0" 1
Displaying zeros in cells 2
ACCESS = "NO" BUT EXCEL = "0" 2
How do I get 00 or 01 from XML to Excel it displays as 0 or 1? 1
Importing Data from Access 3
Access to Excel check box conversion 5
No Results returned from Access query 3

Top