Remove quotation marks from data table

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)