I'm getting an Overflow error in Excel when I try to run one of my macros that's supposed to get some data from Access. The Macro works fine but when I try to get some values from a querry where I have some fields with #NUM! error I'm getting the Overflow error. There's nothing fancy about my code... when I try to get the value is something like below:
ws2.Cells(rData, cData + 5).Value = rs.Fields(ws.Cells(rParam, cParam + 6).Value).Value
and in Access my fields look like this:
When it gets to the record with #Num! field I'm getting the Overflow error in Excel. Is there some solution for this issue? Thank you very much!
