RevitTricks

Process: Export a Revit library file - maintains the same name as the family (This is critical) Create an EXCEL file same-name XLSM macro enabled Create a Worksheet "EXPORT" Create other tabs to build data sheets Create a sheet and use DATA LINK to bring in the exported library Copy the important 1st row IDs for the Variable names and types over. All of them are not necessary - only the ones with data Library export ONLY exports parameters that have data in them somewhere Order doesn't matter. Paste the code below into a module Run it to export the "EXPORT" tab Excel saves-as the [excel filename.TXT] Excel saves as the [excel filename.XMSM] Refresh the data source for updates SAVE OFTEN! Version 2.0- The Textfile in VBA has issues - keeps trying to write in Unicode and Kanji instead of basic ASCII. Also Revit format for families is noting in cell 1,1 and all Line Feeds (Not CRLFS or CRs ) at the end of lines. Attribute VB_Nam...

On the Road to VDC Integration~ Geeking out over Revit and MS Access data connections... Personal breakthrough- I finally got an great connection from Revit 2015 to MS Access through a plugin called DBConnect.  I had to install the ODBCx64 drivers downloaded from Microsoft as even whn I installed the x64 version of office to go with my x64bit everythign else it insisted on rverting to teh x32 ODBC drivers: http://www.microsoft.com/en-us/download/details.aspx?id=23734  i got from this very useful dude!~ Found this helpful Me Too 9 Answer Scottgem  replied on  January 22, 2010 MVP You can download the drivers here: http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=e This file will add Access to the list of file types in the ODBC administrator. Not sure if its 32 or 64 bit. But it worked on a machine running 64bit Win 7 Hope this helps, Scott<> P.S. Pleas...