|
|
| This small Excel macro allows you to execute SQL commands on any ODBC data source directly in Excel and will paste the results in an Excel sheet where you can sort, filter and further manipulate the data. |
|
| Updated |
Apr 27, 2008 13:26:45 | | Size | 29 kb | | Licence | Freeware | | Status | Major Update | | Languages | English | | Tags | SQL, ODBC, Query, Database | | OS | Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003 | | Homepage | jobs-at-large.co.za | | Email | info@jobs-at-large.co.za | | Author | Dirk Wessels |
|
|
click for full size
|
| Other author's software: | - Excel List Compare 1 This useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on seperate rows.
| | Show all author's software |
Description: This small Excel macro allows you to execute SQL commands on any ODBC data source directly in Excel and will paste the results in an Excel sheet where you can sort, filter and further manipulate the data. Useful to quickly extract data from a database and manipulate it within excel. No need to copy and paste large sets of data from other programs to gain the full functionality of Excel. | Short tags: SQL, ODBC, Query, Database | System Requirements: MS Excel 97 or higher | Find last version of Select to Excel | |
| Free Download Select to Excel 2 from jobs-at-large.co.za |
| Similar software shotlights: | - SQL Drill Freeware 1.4 SQL Drill Freeware Excel Add-In, Simplify data retrieval from SQL Server, Oracle, Sybase, MySQL and any other ODBC compliant database. SQL Drill adds easy database access to Ms Excel. For more
| | Find all software similar on Select to Excel 2 |
| Similar smart reviews: | - Select Fast! Improve query performance. Select Fast! is unique software created by a professional developer to ease the life and work of colleagues. Select Fast! for Oracle is a tool for automating the repetitive tasks associated with the SQL tuning process on Oracle databases. The vital purpose of this program is to help you find the best action to improve the performance of the query. Check out this excellent
- Database Tour Pro 5.1.0.715. Manage your database with variety of functions! For a software developer, a «Swiss knife»-style tool can be incredibly useful, but only when that?s the «right» tool. The problem is, nobody can tell you exactly, how to determine whether a tool is «right». A right tool must be full-featured, but it must not be overloaded with features; a right tool must have laconic and functional interface, but
- DecryptSQL, Conquer Encrypted Queries Remember the plot of any blockbuster or spy movie you watched recently? A good guy pursues a bad but clever secret agent, almost captures him, but
Suddenly, the bad guys traces disappear, and the good guy has little or no clue of where the trace would continue. Dealing with someone elses code is a lot similar. As soon as you decide youve figured
- Excel Workbook Splitter 1.05, Fastest And Easiest Way Trends in todays software industry have brought us many monster-like huge «suites». In fact, «multifeatured and universal software suites» take any niche where enough users can be found. It is not that bad, these suites are typically really useful and pleasant to use, but they dont suit many situations, when you need to do one easy operation but many times
- Excel Merge Tool: Few Clicks that Save Hours Merging a report out of a multitude of Excel spreadsheets is quite a challenge. Although data from a couple of spreadsheets could be merged by hand, with the copy/paste command and a bit of patience, merging data from a few dozens or hundreds of tables requires totally different approaches. Excel Merge Tool provides the functionality you need to merge
- Tidycode Pl/Sql Formatter 2.4.2, Making It Pretty This utility can seem «just a small helper», but detailed analysis can say you it is really smart and really helpful (Ill even say indispensable) for almost any database programmer. Its functionality can be easily guessed by name: it just formats PL/SQL code (as well as plain good SQL), and the way he does it can be characterized as «just right»
- Ambrose G. Bierce Selected Works, Teaching From an Astonishing Person Ambrose Gwinnett Bierce was a strange and a wise American. Even his life was unusual: he resigned a very successful Army career to become a journalist, an editor and a writer. He was a public atheist in the XIXth century, when it was a bad fortune; he had published sarcastic «Devils Dictionary» just before the time when sarcasm became popular
- Visual SQL Designer. Ease Your Work With Data. Visual SQL-Designer is powerful software that can easily create complex SQL queries for any database. With this useful tool, you will be able to construct the most part of necessary queries using just visual interface of the user. That is really convenient. Now, when you have got Visual SQL designer, you do not have to spend hours creating queries, whether you are good at SQL or have
- Coollector 2.03, Your Own Movie Database Coollector is a completely free program for storing movie-related information on all movies of yours: which movies youve seen and how much you liked them, which movies youve got in your collection and which you just want to have. It sounds like youve seen thousands of programs of this kind, but youve never seen something like THIS
| | Find all smart reviews similar on Select to Excel 2 |
|