Paras Ahuja wrote:Hi everyone,
I am trying to copy records from excel to ms-access using JDBC-ODBC Driver. However, this error keeps on coming:
java.sql.SQLException: [Microsoft][ODBC Excel Driver] You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again.
Let me tell you when i run the same program when there are few records in the table,it runs perfectly without generating error. But my actual excel sheet has around 7000 records and when i try to transfer that whole data,it gives this irritating error which i can't even understand. I am using both MS Access and Excel 2010.
Please help.....
Thanks in advance...
The JDBC-ODBC Bridge driver is recommended only for experimental use or when no other alternative is available.
SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6 - OCEJPAD 6
How To Ask Questions How To Answer Questions
Paras Ahuja wrote:Hi Rob,
But when i copied these records containing values like "NA", "1-141972991" and "" in OMS_OrderNo into another sheet and then try to transfer,it transfers perfectly.
Does it has to do smthng with the size of data i'm transferring.
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |