SQLite Bulk Import

I am sure there is no easy way to do this but I have ~400 excel files containing data. Each excel file contains the same headers. Is there an easy way of bulk inserting all 4开发者_开发技巧00 files at one time or in some form of batch process instead of doing in manually?

Thanks.

You could put your Excel files into a folder, then write a program to read their contents into a data table (either all at once or in batches) and then write the contents to DB using SqlBulkCopy class.