Connexa Excel add-ins allow you to turn a spreadsheet into a powerful tool for you and your co-workers.
Some of the advantages:
It is possible to link an Excel range into an Access database as a table. In this way you can maintain data in Excel while storing it in the linked table in MS Access. Although it is very useful for simple data maintenance this solution may not be suitable when your data requirements increase. You may need to enforce relationships between tables ('referential integrity'). Or you have to define primary keys or indexes for tables. This is where Connexa XS comes in. It allows you to enforce the restrictions you defined in a MS Access … [Read More...]
With the Connexa XS Excel add-in you can explore and edit data in a MS Access database. Lately we've been asked increasingly whether it would also be possible to write back changes to … [Read More...]