How to Create Excel Spreadsheets With MySQL. When you use MySQL to query a database, you have the ability to view results from that query on your screen or send them to a text file.

The Connecting to Database window will appear first, ... View the SQL query to see how the code retrieves data from the external data source. ... How to Create Excel Spreadsheets With MySQL.

I'm coming from a MS SQL Server background, where I would just create a job and import for this, and I'd be all set. I don't know MySQL well at all, so I was hoping someone could point me in the ...