ニューコム List of Products and Services

"dbSheet EX" is software designed to make existing business systems built with Excel/Access more user-friendly. We offer three versions: "Excel Compatible," "Access Compatible," and "Web Compatible." Please feel free to contact us if you have any inquiries. 【Product Lineup】 ■ Excel Compatible ■ Access Compatible ■ Web Compatible *For more details, please refer to the related links or feel free to contact us.

The Excel-compatible version of "dbSheet EX" is software that enables centralized management of Excel data that has been constructed by field personnel in a database. Complex Excel files using functions and macros, as well as vast amounts of Excel workbooks, can be managed collectively in the database. By developing the system based on the customer's Excel, and being able to utilize Excel's features and usability as they are, it allows for an implementation that minimizes the burden on the field. 【Product Composition】 ■ Server Version ■ Development Version ■ Execution Version *For more details, please refer to the related links or feel free to contact us.

The Access-compatible version of "dbSheet EX" has already been developed and is operational. By incorporating an API into the existing Access system, it is possible to realize a web system that allows for centralized management of data across multiple locations. Data will be migrated from ACCDB to the server's database. We provide support tools for migrating the table structure and data from ACCDB to the server's database. Additionally, the application components of the existing Access system (forms, queries, reports, modules, etc.) can be reused almost as they are. The tables within the Access files on client PCs will be used as temporary (work) tables when interacting with the dbSheet server version. 【Features】 ■ File format is ACCDB ■ Login authentication via the server ■ Permission management by group is possible ■ Centralized management of user operation logs ■ Concurrency control during data updates *For more details, please refer to the related links or feel free to contact us.

By using the Web API provided by "dbSheet EX," it becomes easy to utilize the database under our product's management, including exclusive control, from smartphones and tablets. Additionally, by using the Web Portal (which utilizes the Web API), you can create web projects that operate in browsers compatible with our product with no-code/low-code. Please feel free to contact us if you have any inquiries. 【Main processes possible with the Web API (partial)】 ■ Token issuance ■ Log off ■ Data retrieval ■ Data update ■ Pessimistic lock release *For more details, please refer to the related links or feel free to contact us.