Data Base in Excel?

Asked

Viewed 53 times

0

Guys, I have a question. I Googled and found nothing related, but there could be someone who knows. You can put a Database () in the Excel ?

I wanted to export a list of Clients I have in Mysql to an Excel table, and I don’t know how. Is there any way I can get them to communicate or I’ll have to type client by client ?

mysql database

  • Search for odbc connector for Mysql. You can extract the information with it.

  • 1

    One option would be to export the database records already to a format that can be opened in Excel. But you need to see if the tool to which you are managing the database offers this feature. Generally the file format is .csv.

  • Exel is EXCEL? Since you typed 3x the same way, I was wondering. If you want to export to EXCEL, then you can do what Carlos said, to do it, use the answer that is in Soen http://stackoverflow.com/questions/21253704/how-to-save-mysql-query-output-to-excelor-txt-file?noredirect=1&lq=1 or use Power Query https://support.office.com/en/article/Connect-a-Mysql-Power-Query-8760c647-88b9-409d-b312-6ea8f84a269b

1 answer

0

Browser other questions tagged mysql database

You are not signed in. Login or sign up in order to post.