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.

Use the Excel file as an ODBC data source (connection string info here), and your MySQL database as the destination (using their ODBC connector). What OS is your process running on?

How to Read the Data From an Excel Sheet Using VB Macros Coding. Excel sheets read data in cells using cell references, which are the addresses that identify each cell.