I have a xls (4000+ of them actually) that I need to import into sql server. The xls has different formatting in different cells. For example the first two rows may contain name, ssn, etc and rows 5 - unlimited contain semi formatted data. However within that formatted portion of the data I need to iteratively address each row and depending on the data in that row, enter one to many records into a separate sql server table. I have read through Chapter 8 of this book and perused the remaining chapters and am wondering if I can even do this w/o some sort of .Net code (I'm not a programmer). If anyone can provide some direction or hints in the direction I should take or places I should look for an example like this, I would appreciate it

thanks