C# importing Excel
This code is throwing an exception, I know its due to the INTO clause can someone please point out my mistake I cannot seem to find it.

        "SELECT Brand,`Manufacturer Code`,Description,`Dove Code`,Price,`Stock Level` "
                + "INTO " + pBrand + "," + pManufacturer + "," + pDescription + "," + pDoveCode + "," + pPrice + "," + pStock
                + " FROM [Stock$]", newConnection

Thank you!
P.S. I know the other two lines of code above and below the INTO clause are working.
C# importing Excel
===

This code is throwing an exception, I know its due to the INTO clause can someone please point out my mistake I cannot seem to find it.

        "SELECT Brand,`Manufacturer Code`,Description,`Dove Code`,Price,`Stock Level` "
                + "INTO " + pBrand + "," + pManufacturer + "," + pDescription + "," + pDoveCode + "," + pPrice + "," + pStock
                + " FROM [Stock$]", newConnection

Thank you!
P.S. I know the other two lines of code above and below the INTO clause are working.