Here are some extra steps you should perform in Excel spreadsheet:ġ7. (For queries that you run on regular basis you Using this technique you can get into Excel spreadsheet the output of Drag and drop the result into Excel spreadsheet Press CTRL + A to highlight the result setġ6. Generated by Object Browser to clipboard and paste it to current open Editorġ5. If you need to write join you can save select statement Now you will have a select statement in the Editor Pane. Right click on the table Customers in database Northwind.ġ2. Should use Object Browser to get all tables and column names.ġ0. The next step is to get select statement using the Object Browser. Once you setup "Tab delimited" option in Results Output Format dialog box Select "Tab delimited" option in "Results Output Format" window!!!!!
Make sure that you have "Tab delimited" option in Results Output Formatħ. Now, in the SQL Query Analyzer, we need to get Results in text! Open an Excel spreadsheet where you will place the results. But wait - there is a little trick you should know beforeġ. Method 1Highlight, drag and drop a result set from the Results Pane intoĮxcel spreadsheet.
0 kommentar(er)
