Date Error using Excel Link in Access (1 Viewer)

[sportsguy]

I have linked an excel spreadsheet within access, and a particular field is formatted as data. If one of the column cells is MT, (empty), then the view returns #num error.

Question is how to trap that error to convert to a date or null, or something else?

thanks in advance. . .

sportsguy