Data Load Problem

Hi all,

I have some data in a CSV file that looks like this:

<Column Name1>, <Column Name2>, <Column Name3>, <Column NameN>
<Column Value1>, <Column Value2>, <Column Value3>, <Column ValueN>
<Blank Line>
<Column Name1>, <Column Name2>, <Column Name3>, <Column Name4>, <Column NameN>
<Column Value1>, <Column Value2>, <Column Value3>, <Column Value4>, <Column ValueN>

The rub is that I don't know how many columns I am going to have but each <Column Name> has a <Column Value>.

I need to load the data into different tables based on the <Column Name>.

Any ideas?

Thanks for all the information this forum has very helpful!!!

What would really be nice is that if I could load these into a hash table where the key was <Column Name> and the value was <Column Value>.

Anyone ever done anything like that?

Thanks!