[header] How to embed a sql query in microsoft excel [title] Go to data tab and select from other sources as shown in the screen shot below. [title] Select " from data connection wizard " in the drop down. [title] Data connection wizard will open.
[header] How to embed a sql query in microsoft excel [title] Go to data tab and select from other sources as shown in the screen shot below. [title] Select " from data connection wizard " in the drop down. [title] Data connection wizard will open.
[title] Click on the " current " tab. [title] Select " show current " in the pop-up to show the typical data analysis options. [title] Resize the notepad to just short screen level. [title] Right click on the file from your data connection wizard. [title] Enter all the entries entered in your sql query into the " + " field. [title] Type in the required keywords for each entry. [step] Select " odbc dsn " from the available option and click " next ". [title] Connect to odbc data source window appears.