Jalal said:
Need to resolve the error (#Num!) while linking tables from Excel 2003
to
Access 2003. Had matched field proprieties, still getting (#Num!)
error, that
cannot modify in access linked table.
Hi Jalal
I've been fighting that #Num! error in a linked Excel 2003 to Access
2003 for some time now and have done so many different things to combat
it that I really don't know what solved it (if indeed I have solved it,
or if it's still going to bite me again.)
I'm going to assume, since you said linked table, that this is data that
is continually being revised in Excel so you intend for this to be a
permanent link.
In the other responses I read I saw a reference to "Access looks at the
first row to assign the data type"; and "Access looks at the first 8
rows to assign the data type." I believe there is someplace in Access
you can change how many rows Access looks at when linking to Excel; I'm
sorry, I can't tell you where to find it.
Try inserting one new row at the top of your data to set the format for
Access. In every column that you might possibly have mixed data types
in, enter the word "mixed" or "text" as the value of that cell so that
when Access does the link it will set that column data type to text.
After this row is completed, save the workbook, go to Access, delete
your linked table and set up the link again. Hopefully this will work
for you.
Post back and let us know if you're still having trouble.