Search Results for "excel-addins"

Spreadsheet Compare (Excel compare) is a Microsoft Excel Add-In, written in VBA, that performs a cell-by-cell comparison of Worksheets within the same or different Workbooks. Requires Excel 2000 or later. Check out the Home Page for more info!

...You can dump the tables, views, column descriptions, data types/lengths/sizes/precision, key constraints, and othr information. Results can be instantly exported to CSV, Excel, or even PDF. You can generate just the comments script for tables and columns for you to edit and run, then put under source control. You can output the SQL script used to generate the data dictionary for you own use embedding into your systems and tools.

This database modeling utility is an excel workbook to help you to design database. It supports DB2, MariaDB, MySQL, Oracle, SQLite and SQL Server. In the excel workbook, you can define database, generate SQL scripts and import database definition from database. The office site is https://github.com/snyang/Database-Modeling-Excel

Excel allows the simple creation of reports and tables, this project is to create an API for the manipulation of Census and other data in such a way that customizable reports and tables can easily be generated for any (and aggregated) geographies from Census and other available data.

...However, the columns (fields) can easily modified, added or deleted so that the database can be customised according to your needs. Database Pro is available in file formats for both Excel and OpenOffice. The Excel version is a VBA project and the OpenOffice version uses OOo Basic. Please note that the database does not currently work with LibreOffice due to a couple of bugs in the LibreOffice program.

SQLiteCel is a simple Excel Interface to SQLite designed to help you edit, view and analyze data from SQLite databases.