SQL error

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.

Hi ,

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

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

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

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