how can i read multi csv files from local folder

Question

how can I read multi csv files from a local folder and insert them into a database table using bulk insert