I wrote a code to export my data in gridview to excel

Question

Hi,
I wrote a code to export my data in gridview to excel. But at runtime it throws an exception saying "syntax error in INSERT TO" on execution of the command. I stepped through the code to see the output of the sql statement and I see nothing wrong with it. Can anyone assist me quickly on this please? Very many thanks in advance.


NB: The table creates perfectly, but the INSERT statement gives the exception.


I attached my source code here for your perusal.