Hi
I setup an Access DB where field "ID" is primary.
In ASPRunner I set field "ID" as key.
When I import an XLS everything works fine.
When I try to reimport the XLS I get this error:
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/_services/tkamo/agenda_obed_mobi/admin/Agenda_Mobilityimport.asp, line 205
Line 205 is:
rstmp.open "select * from " & AddTableWrappers(strOriginalTableName) & " " & where, dbConnection
In earlier posting I found that reimporting is handled by ASPRunner as an update which is exactly what I'm trying to achieve.
How do I have to setup my Acces DB / ASPRunner (keys, list, add_ etc.) to make it running?
Any help is appreciated.
Philip