Remove meta-data above header row of CSV files when importing

I have several CSV files saved in the same folder. I am trying to import them all at once.

The problem is that each CSV file has 9 rows of meta-data before the header row, like this:

So I cannot even parse the header rows correctly:

How do I programmatically remove 9 rows from each file before parsing?

ImkeF @v-juanli-msft @Nolock Anonymous ?

Tks!