Unable to insert Access queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When trying to use ms-query to import data from an Access database, I've found that it doesn't allow me to open some of the queries (views) from access. It seems that the queries I have trouble importing have the nz() function in calculated fields of the access queries (views) (or in a sub-query). Is this simply not supported or is there a way to work around it?
 
In the Access query, instead of Nz, use an IIF formula. For example:

EstHrsCalc: IIf(IsNull([EstHrs]),0,[EstHrs])
 
Back
Top