I have a data table with more than 1,048,576 rows of data which is the limit of microsoft and hence cannot use the Table to Excel function. I tried to export to txt file and then open in excel but still no luck. Is there an alternative that you have used to deal with these larger tables? There are about 10 million rows total. I am not opposed to working in python.
Thanks in advance.