I am using INSERT statement to execute the program. And the error has occured : "Data mismatch in criteria expression". I am checking my database but I could not find the error. Can you help me to fix the program.
I am appreciate for your help!!!!!
Last edited by thedeathnotes210x; November 13th, 2012 at 10:24 PM.
Now the sample Excel sheet included, has a problem with some of those Ranges...
IE: Column J, M, AC, AD (row 7) & AE (row 7) all have calculations in them and not Actual Values, These could be the source of your problem.....
Now the columns that have been defined as number in access need to receive a (Unformated) number before the insert will work.. So dont use ' on the numbers, because it designates Strings/Text.... Remove all number formatting including Currency/Weight/ Volume marks so that 2 413.98 cm3 is passed as 2413.98 <- NOTE: Not even a space is allowed.
Sort out these two problems and you should be able to complete the SQL insert command....
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.