Tuesday, May 5, 2015

[ETL] Dynamic CSV ripper, complete but basic

I realized that while my other version (previous post) works great on a series of files on multiple machines, today I just needed an ultra-simple one that takes a presented filename, and inserts the matching fields into a table.  So, here you go!

TL;DR - take a CSV file with headers.
            Match this file to an existing table. (Give this code that table's name)
            Insert the matching fields into that table.

Prerequisite: requires Jeff Moden's 8k Splitter.

No comments: