1. change data type for Byte to Integer
2. Remove @ in the Format property
3. put AutoNumber field last (am assuming you are not importing into this one)
4. change fieldnames for Current, Timestamp, Values -- these are all reserved words

@Crystal , try that all but no luck.Also yes i am not importing Auto Number.For import i am using VBA code which is in the above attach DB.

@Jeffrey Coachman, you are right was using old, change to the one you mention but still the same error. I even check the excel file , both have the same data types also but i am not able to understand why this error is still there.