Time to revisit the Power Pivot Import Wizard
I have learnt a lot over the last year working full time as a Power Pivot professional. And some of the things that I dismissed as "not useful" very early on have turned out to be very useful indeed. The second option in the Table Import Wizard is a case in point.
Read more...