Select to Excel 2

Sponsored Links

Select to Excel 2 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 30KB
Platform: Windows 2003, XP, 2000, 98, Me, NT
License: Freeware
Price: Free
Downloads: 716
Date added: 2008-05-16
Publisher: PSP Software

Select to Excel 2 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.

Some ODBC databases do not have convenient SQL query tools. For example, I work with Transact ODBC (U/SQL) every day and their query tool does not allow you to copy results and paste it into Excel. I often need to extract some data for a client and email it to them in Excel. In the past I used to change a generic PHP page to give me the results in an HTML table, which I could copy into Excel. This works, until you need to extract a couple of hundred or thousand rows, in which case it takes a couple of minutes just to copy the HTML table into memory. With this macro, the results are immediately available in Excel.

Theres nothing fancy about this macro and it will only be useful to people who are comfortable with SQL and probably have the skills to develop something like this themselves. This is why I am giving it away for free and why the source code is available to you to alter as you wish. My experience though, is that if I find something useful, there will be other people whod also find it useful in their own day-to-day lives. Have a look at it. If you can use it, go ahead - otherwise, nothing lost.

Select to Excel 2 Screenshot

Select to Excel 2 Keywords

Bookmark Select to Excel 2

Hyperlink code:
Link for forum:

Select to Excel 2 Copyright do not provide cracks, serial numbers etc for Select to Excel 2. Any sharing links from, or are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Featured Software

Want to place your software product here?
Please contact us for consideration.

Version History
Related Software
Gps to Excel - Add GPS data into an Excel file Free Download
Automatically Summarize Data and Reuse Customized Excel Chart Types. Free Download
SQL Excel Freeware Excel Add-In : Simplify data retrieval from SQL Server, Oracle, Sybase, MY SQL and any other ODBC compliant database. SQL Excel adds easy database access to MS Excel. Works with any ODBC compatible data source. Genuine Freeware! NO Ads, NO Spyware, NO Viruses NO Time limits. For more information, please look at Free Download
ad-hoc formatting of Excel list data Free Download
Export Table for IBM DB2 helps to save tables data to Excel file Free Download
maintaining & organizing data in microsoft excel Free Download
Beyond The Basics & Managing & Tabulating Data in Excel. Free Download
Export Table for Oracle Server helps to save tables data to Excel spreadsheet. The program has easy to use wizard interface. All modern versions of Oracle Server and all versions of Microsoft Excel are supported. A few options make export process more flexible. This handy utility helps database users create Excel spreadsheet for selected table within seconds. Free Download