|
|
Database
| 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
|
|
|
