SQL error

[Arjun_Reddy (Reddy)]

HI guys,
in my excel sheet there are 1000 line items all are entering to SQL. But some getting error
(lakshmi’s) or any ('s) values are not entering to SQL. any solutions.

[Priyanka_Ramesh]

Hi ,

Try to Change the (‘s ) as put single quote twice (’'s)

[GBK]

@Arjun_Reddy - you can try to add escape sequence for the special chars by adding
\'

[Arjun_Reddy (Reddy)]

im sending as string to sql server.so how can i change

[GBK]

@Arjun_Reddy - you can do a find and replace single quote ’ with \'