RevitCity.com Logo

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

Welcome !

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

 

Forums

Forums >> Revit Building >> Technical Support >> Exporting Materials List???

Search this ThreadSearch this Thread | Page 1 of 1 |

Fri, Aug 18, 2006 at 10:25:11 PM | Exporting Materials List???

#1

sashk


active

Joined: Mon, Oct 10, 2005
20 Posts
No Rating


I have tried to export ODBC via excel file, but i am having trouble understanding how the hell it works. It makes no sense to me. Is there a way to export the Materials Section from Revit to an Excel file? I would like a print out of it so that I can check all of my materials, their assigned colors, etc. Any help would be great. If anyone can give me some details step-by-step instructions on the exporting of OBDC to an Excel file, that would be cool too. Thanks

This user is offline

 

Wed, Sep 24, 2008 at 6:09:04 PM | Exporting Materials List???

#2

lorne17


active
lorne17 Avatar

Joined: Wed, Aug 29, 2007
417 Posts
3.5 Stars: 7 Votes


Hello there,

 

If you are merely trying to get a schedule into excel format, you don't need OBDC.  All you need to do is got  to your schedule.  Then go to file>export>schedule.  It'll save it as a delimiter text file.  Then go to Excel.  Go to Data>import external data...>import data.  Go find your .txt delimiter text file and you'll get a few dialogs to edit your excel layout.  I just leave as default, and click finish.  You'll see all your schedule in.  

 Now you'll probably have to edit it a bit as you lose merged cells etc.  But a lot easier than typing it out!

 

Hope that helps,

Lorne


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

AutoDesk Revit Certified Professional

Denver, CO

Revit Architecture

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Materials List

Revit Building >> Technical Support

Tue, Feb 13, 2007 at 8:04:40 PM

2

Materials not exporting to dwf properly

Revit Building >> Technical Support

Fri, Oct 7, 2011 at 3:00:47 PM

2

Revit 2009: detailings: tag that list all wall's materials

Revit Building >> Technical Support

Mon, Oct 12, 2009 at 12:47:25 PM

2

Exporting FBX from

Revit Building >> Technical Support

Thu, Jul 22, 2010 at 5:36:28 PM

0

Another ODBC question

Revit Building >> Technical Support

Tue, Sep 23, 2008 at 3:14:47 PM

0

Site Stats

Members:

1780679

Objects:

22480

Forum Posts:

151950

Job Listings:

3

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: 14.3317

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights