使用VB和宏在excel中创建查询

I have a lot of data in excel with different columns. My task is to create insert statement for each row. I have done using concatenate function of excel but I want to automate this method. The other task is to replace ' (single quotes) with ''(2 single quotes) so that characters can be adjusted in the sql statement. The main is once I get the excel, I run my script which will automatically make all the queries. And after that, I will run those queries manually in SQL developer or TOAD.I have a lot of data in excel with different co