Select to Excel 2
Downloads:
Publisher: PSP Software
File size: 30KB
OS: Windows 2003, XP, 2000, 98, Me, NT
Date added: 2009-10-27
Homepage: http://www.pspsoftware.co.za
Category: Business
Select to Excel 2 Description
"Execute SQL commands on any ODBC data source."
Edit by : 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.
There's 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 who'd 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.
you can free download Select to Excel 2 now.
Select to Excel 2 Keywords
Select to Excel 2 Related Software
- Select-a-Net
A Windows utility for managing multiple network and web browser configurations. - Explorer for Microsoft Excel
Manage Excel sheets, links, Names, comments, conditional formatting, hyperlinks. - Excel Calendar Template
Easily create a stylish monthly calendar in Microsoft Excel. Good for any year. - Database Viewer(Access,Excel,Oracle)
View Microsoft Access, Excel, Oracle, any ODBC enable database on Palm. - Select to Excel
Execute SQL commands on any ODBC data source. - Excel List Compare
Excel macro compares row equality of 2 lists based on 1 to 4 columns - TimeClick
Quickly capture project time with the click of a mouse button
Select to Excel 2 Publisher's Software
Popular Searches
Hot Downloads Software
New Release Software