Easily import database data into Excel or Calc for simple searching and updating.
"KeySQL" is a tool that allows you to easily use database data from familiar Microsoft Excel or OpenOffice.org Calc. With KeySQL, you can simply set search conditions with your mouse to import database data into Excel or Calc worksheets, making it easy to reference or update data. Additionally, you can process data in Microsoft Excel or OpenOffice.org Calc to create reports and perform analysis. There is no need for complicated SQL statements or programming; it is a tool that enables "end-user computing." For more details, please contact us.
Inquire About This Product
basic information
**Features** ○ Easy operability → Even those who are not familiar with SQL can easily set data search conditions using the GUI. → It is also possible to set easy-to-understand aliases in Japanese or other languages for tables and columns, separate from the actual definitions. ○ Rich macro functionality → The set search conditions can be saved as a macro file, allowing for data searches under the same conditions every time. → KeySQL automatically generates VBA macros for Excel and macros for OpenOffice.org Basic. ○ Data update functionality (for search/update version only) → If you change the data imported into Excel or Calc, those changes can be reflected in the database. → Not only changes but also new data insertion and deletion are possible. ○ Data aggregation through cross-tabulation → Supports cross-tabulation, which is optimal for data analysis, allowing you to aggregate and analyze data from various angles while checking results before importing into Excel or Calc. ○ Generic output formats / Compatible with OpenOffice.org Calc ○ Compatible with various databases ● For more details, please contact us.
Price information
Please contact us.
Delivery Time
※Please contact us.
Applications/Examples of results
For more details, please contact us.
Company information
Assist not only carefully selects and provides high-quality and high-performance products that Japanese companies need, but also offers various services related to product implementation to maximize the effectiveness of the products, supporting users until they can fully utilize the packaged software.