#num! error when linking excel table in Access 2002

Guest · May 4, 2007

Encountering the above error when linking excel table into Access 2002. Have
tried changing format of table in Excel so everything reads as either number
or general or text. Despite these attempts it's still producing the same
error in certain cells in one particular column. Help!

molsonexpert · May 4, 2007

I had a similar issue and gave up (it wasn't important at the time). Try the
following links and see if either works for you (and if you find a solution,
post back, because I'd still be interested in a fix):

http://support.microsoft.com/kb/208414

http://support.microsoft.com/kb/282263/en-us

#num! error when linking excel table in Access 2002

Guest

molsonexpert