Thanks for the advice on the file, I will make sure I do the scripts next time and I will give your suggestion a try.

Tango, SSChampion, and Phil, thank you so much for the help on this and I learned something new. Hope you have a good weekend.

TangoVictor,

Thanks for the help, do you happen to have an example where this has been done, I can't find clear example of how to setup the process up? I do...

Brian, I figured out what I did wrong, sorry for the confusion on this and thank you so much for the help, I will remember from now on if I...

Hi Jeff, yes it will since I am sure it will, at some point of the data owners is going to add a comments field which will end up being...

Hi Brian, Thank you for this above, I can see what you have done but I tried to run it and it is not unpivoting the data for me, any...

I have been able to get the data loaded to a table in SQL using the ADO engine, I have attached a data file to help.

Phil thanks for the reminder, I will make sure I get the install completed.

Hi Jeff,

Thanks for all the help on this, on this instance of SQL I do have the ability to use the ADO connection to load the files and yes the...

Jeff, Thank you for the help on this I have attached 3 files with what I have been seeing in the actual data files. You will notice some have all...

Phil,

Thank you for the quick response. I wish I had the luxury of locking down the format but since I have inherited this, I am having to play the cards...