RevitCity.com Logo

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

Welcome !

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

 

Forums

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 8:30:30 PM | ODBC export to Excel

#1

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

 

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

#2

TomDorner


active

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.

 


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

Tom

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

 

This user is offline

View Website

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

#3

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

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

ODBC Database.....Help

Revit Building >> Technical Support

Thu, Aug 17, 2006 at 3:27:34 AM

1

Export data base to excel slowing down Revit

Revit Building >> Technical Support

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

0

Revit 2015 ODBC Error

Revit Building >> Technical Support

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

1

Revit Export into ODBC Database

General Discussion >> Revit Project Management

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

1

Exporting Materials List???

Revit Building >> Technical Support

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

1

Site Stats

Members:

1820631

Objects:

22574

Forum Posts:

152006

Job Listings:

4

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | 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.1290

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights