Incorrect syntax near '3'.

Posted by Cibin under VB.NET on 7/18/2013 | Points: 10 | Views : 3715 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

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.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Palraj001 on: 7/31/2013 [Member] Starter | Points: 25

0	Hi Cibin , I guess You are taking string values from access and trying to insert in SQL. in SQL we use '' (single codes) to insert Varchar values. when you read and insert from the access you forgot to to format the string. This is my Guess. check the data to SQL Query. Regards, Palraj M Cibin, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 7/31/2013 [Member] [MVP] Platinum | Points: 25

0	Can you post the WHERE condition logic and datatypes of respective columns in the table Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Cibin, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts