Quite a few comments on my Revit as a Database post from last week focused on the fact that Microsoft's various versions of 64bit Windows do not include or support a driver for connecting to an Access database via ODBC. The good news is, Microsoft appears to be changing course on this in the upcoming release of Office 2010. Their download site includes both 32 and 64 bit beta versions of their data connectivity component driver. I tested this out in Vista x64 with Revit 2010 x64 and the Office 2010 x64 beta and it works. The bad news: you will have to wait for Office 2010 to ship and many of you do not have a say in when your office upgrades.
_tom
Tom,
Do you know if the drivers will work even if Office 2010 is not installed? .mdb is still .mdb and predates even Access 2007
Posted by: Chris Hubbard | February 19, 2010 at 11:19 AM
Chris, That is a good point. Definitely worth a try. It goes without saying, all of this should not be done with actual production files!
Posted by: Tom Vollaro | February 19, 2010 at 12:18 PM
You can read the odbc in excel, but can you write to odbc from excel?
Revit->ODBC->excel->ODBC->Revit
Posted by: Arno de Lange | March 04, 2010 at 10:08 AM
Arno, You can set up an ODBC connection to write to another data source from Excel. However, Revit DB Link requires an Access or SQL server database as the intermediary because because of all of the complex relationships that must be represented. There have been some API add-ins written to accept data into Revit directly from Excel, but these have all been specialized (see the Excel Model Generator: http://www.extensions4revit.com/n/e4r/850/8)
Posted by: Tom Vollaro | March 04, 2010 at 10:16 AM
software is one of the greatest needs in today's market, I have always considered that every entrepreneur should have a basic knowledges in this field, as many companies depend on these systems to make important decisions.
Posted by: buy viagra | April 09, 2010 at 12:58 PM