Question: how to export sql table data to excel using sql query?
Answer: Step1: Connect Excel to an external data source: your SQL database. Install An ODBC. Install A Driver. Avoid A Common Error. Create a DSN. Step 2: Import your SQL data into Excel. Click Where You Want Your Pivot Table. Click Insert. Click Pivot Table. Click Use an external data source, then Choose Connection.