SQLXL

SQL*XL provides a bridge Between databases and Microsoft Excel. With SQL*XL you have a single interface to all your databases. Convenience and productivity is our Focus. Working with databases was never easier...SQL*XL provides an easy to use bridge between Excel and your databases. SQL*XL adds a new menu and a new toolbar to Excel so database access appears to be native. Through comprehensive dialogs you have interaction with the database.Explore the database...SQL*XL provides a simple way to browse through the tables in your database. This way you can familiarise yourself with the tables and column Details. Extract data from the database...Data can be retrieved from the database and put straight into your Excel spreadsheet. Care is taken to format the data correctly so you can use the data in e.g. Excel calculcations and charts without problems. A one click table dump is provided but the main method for retrieving data is through SQL. Simply type the select statement and SQL*XL retrieves the data into Excel.Data entry & data upload...A full spreadsheet full of data can be inserted with a few simple mouse clicks. Simply prepare the data in your spreadsheet and use the insert multiple rows feature. Feedback is written next to your data rows to indicate whether the insert was successful or not.