Access Appear As !NUM#

[cheer]

When I link the excel into access, attached is the result i see in MS Access. I hv tried to set the all fields as GENERAL, TEXT and etc in MS Excel, but the same output I obtain.

Anyone has resolution for this problem ?

 

[Big Pat]

I had a similar problem recently. I have a linked excel file but I need to append it to another table each time the excel file is updated. But the append would not work.

In the query I appended this instead


cstr(nz([MyExcelFileName].[MyColumnName],"")

The meant that whether I had numbers, text, or blank in my input record, Access always appended TEXT to the destination table.

Does that help you?