Nz error on Excel Import

[Dugantrain]

I have several crosstab queries which use the Nz function to place a zero in any Null field, which work fine. However, when I attempt to import this data in Excel, I get the error that the function Nz is not defined. Is Nz just unrecognized by Excel? If so, how can I get around this problem?

 

[FoFa]

Create a query and use that to feed data to Excel. Put the NZ functions in your query.

 

[Dugantrain]

Yes, the Nz functions are already in the Access queries and these queries run fine. It's when I try to import these queries using Excel that I get the error message.

 

[NOL]

I know that there is no problem when exporting the crosstab queries to Excel.
You could try exporting instead of importing if that works for u .


Gina.