Help - This is driving me crazy... I have 1.9M records in a csv file, when I initially go into Import Wizard, it tells you that it can not load all the records, but once imported, you can go to another worksheet and do another import and exclude the 1,0485,576, from the first worksheet you just loaded... Anyways, I have no idea of where to find the exclude option when trying to load in the additional 900K records, and if you attempt to start at row 1,0485,576, you get a few thousand more rows... this is weird.. I can load the 1.9M into PowerPivot, but then Power Pivot keeps erroring out, hence, I'm trying the Import Wizard approach any assistance is greatly appreciated.. Additionally, if anyone knows how I can copy the 1.9M records out of Powerpivot back into Excel that would be appreciated as well. Thanks, Monte
