Home > Excel > Database


Related Categories

Excel and Access  
This site provides help with MS Excel and Access . There are examples of spreadsheet functions and database program modules. Advice is also given on spreadsheet testing, enhancing graphs, configuring Excel and documenting databases.
Submitted: Oct 09, 2003
Excel Database  
RapidData is a uniquely designed spreadsheet-based development tool that incorporates the main application building functions of a Database program into an extremely user-friendly spreadsheet environment. This completely menu-driven program allows even the most inexperienced users to create detailed and comprehensive data tracking and analysis systems. Unlike other template programs, RapidData allows you to custom design your own Database layouts, complete with mathematical as well as logical Formulas
Submitted: Jul 04, 2005
Excel to MySQL  
Excel-to-MySQL is a program to convert MS Excel spreadsheet into MySQL database. Each worksheet becomes a table, each row becomes a record and each cell becomes a field.
Submitted: Oct 07, 2003
Excel Ad-hoc Analysis  
Ad-hoc reporting tools called MatryxAccess and Matryx98. Provides high-powered query engine linking Excel to all of your ODBC compliant data sources.
Submitted: Jan 24, 2001
Create a Custom ODBC Driver for your data source  
Take advantage of Matlab's support for ODBC/SQL access by making your data source look like a ODBC compliant SQL database. OpenAccess™ allows you to implement a virtual SQL database layer with support for JDBC, ODBC, OLE DB, .NET and Web Services over any data source. Your data instantly becomes accessible to hundreds of reporting, analysis, integration and development tools on Windows and Unix just as if it was a commercial SQL database like Oracle, DB/2 or SQL Server. The data source can be anything such as files, relational stores, object stores, business objects, memory, applications, or Web Service.
Submitted: Aug 18, 2005
Compare Excel files  
4TOPS Compare Files is used to find differences in values or formulas between worksheets or Microsoft® Excel files. It is easy to use and clearly reports where and what the differences are: the Analysis Report the Visualization Report. Can be used as part of an automated process using API.
Submitted: Mar 18, 2006
Spreadsheet with Database Capabilities  
Engineering calculations are typically repeated for different sets of input data and the common practice is to create multiple copies of the same spreadsheet file for repeated calculations, which may result in a maintenance nightmare. Database-enabled spreadsheet eliminates this nightmare, because it enables to keep all different sets of input data in a single file. The site explains simple procedure how to add database capabilities to any spreadsheet.
Submitted: Jan 05, 2007

  Privacy - Trademarks - Feedback - Terms of Use Copyright The MathWorks, Inc.