Assuming you are using Microsoft SQL Server since you mentioned SQLBulkCopy.
To remove quotes from an already existing data, add a function to the database then use that function to fixup the columns containing quotes. If the data is not yet in an SQL Server database, then your VB .NET program should use the
String.Replace
method to remove the quotes before inserting new rows into the database table as stated in VitorHugoGarcia's comment above.
Add a new function to your SQL Server
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION RemoveQuotes
(
@str varchar(800)
)
RETURNS varchar(800)
AS
BEGIN
Declare @x int=1;
Declare @strTemp varchar(800);
Set @strTemp=@str;
WHILE @x>0
BEGIN
SELECT @x=CHARINDEX(CHAR(34),@strTemp,@x)
if @x>0
BEGIN
SELECT @strTemp=STUFF(@strTemp,@x,1,'')
END
END
Return @strTemp
END
Execute an UPDATE statement using the RemoveQuotes function
Update YourTableName
Set col1=RemoveQuotes(col1),col2=RemoveQuote(col2),RemoveQuotes(col3),col2=RemoveQuote(col4)