If you have it available, I would look into using
SSIS
It will allow you to manipulate your data and store in the DB. Also if it is a repeatable task, you can schedule it too. It could be just as quick to set up an SSIS package as it will take care of chunking/commits/rollbacks etc.