|
|
| 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 02:48:15 | | 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.
- TimeClick 1 Log your times spent on each project by clicking on the project name on a menu within your Windows System Tray. Drastically reduces time spent on updating timesheets.
| | 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 Excel 1.01 Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MY SQL and any other ODBC compliant database. For more information, please look at http://www.sqlexcel.net The points
| | 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
- 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
- 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»
- 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
- 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
- ESF Database Convert Like in that old proverb: so many countries, so many customs. I mean so many countries, so many languages; so many databases, so many formats: MySQL, SQL Server, PostgreSQL, Oracle, InterBase, Access, Excel, Paradox, Lotus, dBase, Text and others
but dont give up, there is special software that can help you to deal with all of them. It is ESF Database Convert. ESF
- CompareData 1.4.0, Advanced Database Diff Comparing the content of two databases or their parts is a frequent task of technical specialists in DB-aware environment. Finding differences in two datasets is an important task for migrations (changing DB structure or engine), replications, backup/restore procedures, and other analysis issues. Writing a custom program for each case is inefficient. Fast visual application for
- OTK Custom dbinstaller 2, Database Comes Along Have you ever installed an application that required a database, but had no database in the setup file? What a hassle it was to find the database software, install it on the computer and finally configure it the way that it would actually work with that software! When the preparation was finally over, no strength or desire to continue with the software had remained in the
| | Find all smart reviews similar on Select to Excel 2 |
|