Forum Discussion
using Power Pivot
I have the options of exporting to Excel 2003, Excel 2007, csv, html.
I've tried them all, but they stop exporting before giving me any results. At least the html option showed me there were almost 1.3M records.
The export I'd been using was Excel '07 until the file got too big.
- If connecting directly to your database is not an option then maybe split the export into 2-parts based on date? and then use Power Query to join the 2 exports back together and load to Power Pivot.
If I could split the db by date, I could move on to bigger things.
Unfortunately, all I can select from is the export's name, type (xls, etc.), and folder to save the file.
I've looked around the settings and controls, but haven't found anything that can help.
There is no joy in this Mudville!
Well, my problem got solved & I just found out.
I hadn't been paying attention, evidently, but when I went into the export folder, the file had been exported as csv.
A quick bit of editing, then saving to xlsx & I'm done.
Now, if I could only get my hair to grow back...
Thank you for your time.
