SQLite Bulk Import

Question

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 400 files at one time or in some form of batch process instead of doing in manually?

Thanks.

Answer 1

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.