CODEWITHSUNDEEP
sqlitebulkinsert
Nathan
Nathan

Reputation: 5233

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

Thanks.

Upvotes: 0

Views: 756

Answers (1)

Adam Lear
Adam Lear

Reputation: 38768

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.

Upvotes: 1

Related Questions