Need to create concatenate the shell variable with file content

Hi Guys,

I have a file. Each record needs to inserted into a table. The table also have other columns which needs to be inserted with Shell variables.

The following is the file.

Error code None.
Error Code 1

The shell script is having these variables.

Name=Magesh
Dep=Coding

The output i need should be like this.

Insert into table(col1,col2,col3) values ('Magesh','Coding','Error code None');
Insert into table(col1,col2,col3) values ('Magesh','Coding','Error Code 1');

Basically for all the lines $Name and $Dep needs to be picked up. I am not sure how to pass it to the insert queries.

Cheers!!!!!

$ while read col
> do
> echo "Insert into table(col1,col2,col3) values ('$Name','$Dep','$col');"
> done < x
Insert into table(col1,col2,col3) values ('Magesh','Coding','Error code None');
Insert into table(col1,col2,col3) values ('Magesh','Coding','Error Code 1');
$

Assuming the filename is "x".

Note: I removed the "period" after the "None" from the file.