Search and update the database from the front tool.

Added to bookmarks
Bookmarks list

Bookmark has been removed
Bookmarks list

You can't add any more bookmarks

By registering as a member, you can increase the number of bookmarks you can save and organize them with labels.
Free membership registration

last updated：Sep 14, 2011

アシスト

Official site

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.

Related Link - http://www.ashisuto.co.jp/prod/keysql/index.html

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.