ANN: Use Microsoft Office as a relational Database

[Jim Gordon MVP]

The information is now a live link on my website:

http://www.agentjim.com/MVP/Excel/RelationalOffice.htm

Putting this information together was a large undertaking.

This is pretty big news. For $30 you can buy an ODBC driver that has the
effect of turning Microsoft Office into a fully relational database.

I encourage everyone to check this out and put comments here in the
newsgroup.

Thanks.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[gimme_this_gimme_that]

That's a good development.

What's the advantage of using Excel instead of an Access mdb?

Also, note that the ODBC driver can only be used by other Office
applications, and possibly with PHP.

It' can't be used by Perl, Java, or C (unless you know how to write
ODBC drivers)

 

[Jim Gordon MVP]

Quoting from "(e-mail address removed)"

That's a good development.

What's the advantage of using Excel instead of an Access mdb?

Primarily, there is no Microsoft Access for Mac, so usually it is not an
option unless you use a virtual machine, buy Windows, and buy Access. That's
a lot of money compared to just $30 for an ODBC driver. Excel runs on Mac
and comes with Microsoft Office, so lots of people already have what it
takes except for the ODBC driver.

Also, note that the ODBC driver can only be used by other Office
applications, and possibly with PHP.

Using the driver with PHP:
http://www.actualtechnologies.com/phpsetup.php

It' can't be used by Perl, Java, or C (unless you know how to write
ODBC drivers)

From http://www.actualtechnologies.com/compatibles.php

Development Environments
Omnis Studio by Raining Data: create custom applications which can read and
write data from your ODBC connection. You can also query ODBC data sources
using the integrated SQL Browser feature.

4th Dimension by 4D, Inc: use 4D's wizards to create automatic data entry
and report forms. Use the built-in querying and reporting tools to generate
sophisticated reports with no coding.

PHP, Python and Perl: popular scripting languages for developing web sites
and other types of applications. These languages include support for ODBC
connectivity modules for querying results from various databases.

Dreamweaver by Adobe: a web development tool, enabling users to design,
develop and maintain standards-based websites and applications. Developers
of dynamic sites can connect to databases using Dreamweaver's support for
ODBC.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info