Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

176 Users Online (175 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM



Forums >> Workflow & Implementation >> API & Third Party Apps >> ODBC export to Excel

Search this ThreadSearch this Thread | Page 1 of 1 |

Mon, Mar 19, 2007 at 3:30:30 PM | ODBC export to Excel




Joined: Mon, Mar 19, 2007
2 Posts
No Rating

We need an automated (fool proof) way to export our area calculations into excel.The ODBC export routine is pretty much providing what we need.When exporting about 150 tabs are created. However, all we care about is the AREAS and the LEVELS tabs.Is there a way of limiting the export to have the resulting excel file better streamlined?Andre

This user is offline


Mon, Mar 19, 2007 at 6:25:41 PM | ODBC export to Excel




Joined: Sun, Apr 25, 2004
1207 Posts
4.5 Stars: 25 Votes

ODBC is all or nothing.  You may bebetter off ODBC'ing to MS Access then just link in hte MS Access database to your Excel file.  In Excel go to Data>Import External Data>Import Data [set file type in drop down to*.mdb] choose your Acess file and then a list of tables will appear to choose from.

An alternate method is to export a schedule to a .txt file that yu can open/import into Excel.

Of course you can you MS Access or Cyrstal Reports if you have them and skip Excel altogether.

In any case, be aware that all ODBC areas, volumes and lengths are in metric.  If you are using Imperial units then you will have to build a conversion factor to account for this.





This user is offline

View Website

Sun, Dec 30, 2007 at 3:17:10 PM | ODBC export to Excel




Joined: Fri, Nov 30, 2007
8 Posts
No Rating

I've often found it necessary to write a simple visual basic program to make these sorts of things fool proof.  I don't have a program to do this, though I'm sure it is possible.  The Revit API (programming interface) has exampe code of ODBC export, and If I remember right, one of the programs is to Excel.  Google "Revit API" and also Google Visual Basic Express Edition which is free.


This user is offline


Search this ThreadSearch this Thread | Page 1 of 1 |

Similar Threads

Thread/Thread Starter


Last Post


ODBC Database.....Help

Revit Building >> Technical Support

Wed, Aug 16, 2006 at 10:27:34 PM


Export data base to excel slowing down Revit

Revit Building >> Technical Support

Thu, Jan 22, 2009 at 12:44:41 PM


Revit 2015 ODBC Error

Revit Building >> Technical Support

Tue, Nov 11, 2014 at 12:53:41 PM


Revit Export into ODBC Database

General Discussion >> Revit Project Management

Mon, Aug 24, 2009 at 1:21:53 PM


Exporting Materials List???

Revit Building >> Technical Support

Wed, Sep 24, 2008 at 1:09:04 PM


Site Stats





Forum Posts:


Job Listings:


Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.3003


User Name:


Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search

Clear Highlights

Clear Highlights