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

avoss

active

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

TomDorner

active

Joined: Sun, Apr 25, 2004
1207 Posts

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.

-----------------------------------

Tom

www.reviteer.com   http://twitter.com/Reviteer

This user is offline

View Website

JimMerritt

active

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.

--Jim 

This user is offline

ODBC Database.....Help

1

Export data base to excel slowing down Revit

0

Revit 2015 ODBC Error

1

Revit Export into ODBC Database

1

Exporting Materials List???

1