J
Jim Gordon MVP
Effective today Mac Office can be used a fully relational database.
The formal announcement is to come, but earlier today Actual Technologies
made available on their site the latest version of their Microsoft Access
ODBC driver.
http://www.actualtechnologies.com/product_access.php
Actual Technologies gave me permission to let the cat out of the bag that
today's version of the Microsoft Access driver supports a new data source:
Microsoft Excel workbook files. The link to the download page is:
http://www.actualtechnologies.com/download.php
For the first time in Mac Office you can now have complete control over a
relational database without having to resort to an external database
program.
As of this writing their web page and site makes no mention of this new
capability, but you can download the driver and try it for free (only the
first 3 rows of any query will be returned when in demo mode).
I've put together a draft of documentation about how to use Microsoft Office
as a relational database. The draft and and example workbooks are at this
temporary download location (the link will change when I've finished the
documentation)
http://www.agentjim.com/MVP/Databases.zip
Once you've download the file and unzipped it, put the Databases folder into
your Documents folder. There's a word document called
OfficeAsRelationalDatabase.doc that has the information you will likely need
to get started. You'll find this document in
....
ocumentsatabases:Examples
There are several Excel examples and a workbook that (if you follow the
instructions in the Word document) will connect to the sample data provided.
The sample reports is this Excel Workbook
....ocumentsatabases:Examples:OutPut Reports:Employees Example.xls
The sample data source is this Excel Workbook
....ocumentsatabases:Examplesata:ExampleData.xls
Examples for using this technology with Word and PowerPoint are in the
works. If you know how to use the Data Merge Manager you can get going right
away by doing database queries in Excel and using the result set from Word.
This is really bombshell amazing news. For about $30 US you can turn
Macintosh Office into a fully relational database.
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP info
The formal announcement is to come, but earlier today Actual Technologies
made available on their site the latest version of their Microsoft Access
ODBC driver.
http://www.actualtechnologies.com/product_access.php
Actual Technologies gave me permission to let the cat out of the bag that
today's version of the Microsoft Access driver supports a new data source:
Microsoft Excel workbook files. The link to the download page is:
http://www.actualtechnologies.com/download.php
For the first time in Mac Office you can now have complete control over a
relational database without having to resort to an external database
program.
As of this writing their web page and site makes no mention of this new
capability, but you can download the driver and try it for free (only the
first 3 rows of any query will be returned when in demo mode).
I've put together a draft of documentation about how to use Microsoft Office
as a relational database. The draft and and example workbooks are at this
temporary download location (the link will change when I've finished the
documentation)
http://www.agentjim.com/MVP/Databases.zip
Once you've download the file and unzipped it, put the Databases folder into
your Documents folder. There's a word document called
OfficeAsRelationalDatabase.doc that has the information you will likely need
to get started. You'll find this document in
....
ocumentsatabases:ExamplesThere are several Excel examples and a workbook that (if you follow the
instructions in the Word document) will connect to the sample data provided.
The sample reports is this Excel Workbook
....
ocumentsatabases:Examples:OutPut Reports:Employees Example.xlsThe sample data source is this Excel Workbook
....
ocumentsatabases:Examplesata:ExampleData.xlsExamples for using this technology with Word and PowerPoint are in the
works. If you know how to use the Data Merge Manager you can get going right
away by doing database queries in Excel and using the result set from Word.
This is really bombshell amazing news. For about $30 US you can turn
Macintosh Office into a fully relational database.
--
Jim Gordon
Mac MVP
MVPs are not Microsoft Employees
MVP info