Based on example provided on
Excel connection strings - ConnectionStrings.com[
^] (
Standard alternative section), you have to change
select
statement by defining a range to grab data, for example:
SELECT *
FROM [SheetName$A6:D]
or by
skiping[
^] first 5 rows in code (using Linq):
sqlBulkCopy.WriteToServer(dtExcelData.AsEnumerable().Skip(5));