When i retrieve data from one table in access database and insert to another table in sql database , the following error will occur.." Incorrect syntax near '8' " . For small number of records there is no error. but when copy a large amount of data with WHERE clause , it shows the error. Anyone please help to solve this error..
Thanks in advance.