Mysql To Excel

[Ketan__Patel__0011]

Hello Friends And Qt Experts

Currently i am working on A Large MySQL Project and i have a lot's of data in my MySQL database tables and it is very hard to see in QTableView Or Other Widgets And very hard to Manage The Data.

for this solution i have idea to save MySQL data into Any Excel File For Easy to Use and
we can also say it for data backup

so is there any way to save MySQL data into Excel File ?

if you have any idea for how to do this please help any drop your suggestion

Thanks in advance
And I Hope you all are safe in corona pandemic

[JonB]

@Ketan__Patel__0011
From a Qt programming point of view, just read from tables outputting columns with a , separator to a .csv file, and read that into Excel.

If you want external tools to do it, just Google for Mysql To Excel. There is a whole chapter in the MySQL docs https://dev.mysql.com/doc/mysql-for-excel/en/mysql-for-excel-import.html.