can someone tell me what file format(s) DB Link exports to? I need to be able to get a file to Excel or Access. Does DB Link export directly to .xls or .mdb? I don't have it installed yet or I would figure it out the easy way...sorry
Announcement
Collapse
No announcement yet.
Revit DB Link
Collapse
X
-
Originally posted by Dave Jones View Postcan someone tell me what file format(s) DB Link exports to? I need to be able to get a file to Excel or Access. Does DB Link export directly to .xls or .mdb? I don't have it installed yet or I would figure it out the easy way...sorry
-
Originally posted by hypnox1 View PostIt does both of these formats. However, when I was using it I never got it to work properly with xls format files.I'm retired, if you don't like it, go around!
Comment
-
Originally posted by Dave Jones View Postme either, then I uninstalled it. But now I'm working with an Access developer on some other stuff and I may have him do some investigation into DB-Link from the Access direction. Thanks for the info
Those issues may have been fixed for the 2011 release as I have not used it since 2010. I have since switched to using the Revit Data Transfer Tool which works exclusively with xls files but doesn't seem to have as many problems as DB Link does. It still has its issues though.
Comment
-
Originally posted by hypnox1 View PostI suppose I should warn you that the access side has a lot of limitations and nuances (read as annoyances). When you first build your access export every category has its own table and nothing is linked together. From there you have to manually build links between tables, if needed. Stuff like links and formulas (can't remember if that is what they are called in access) get broken every time you export to access. It's almost best to just work with it the way it gets exported, which is a real pain sometimes.
Those issues may have been fixed for the 2011 release as I have not used it since 2010. I have since switched to using the Revit Data Transfer Tool which works exclusively with xls files but doesn't seem to have as many problems as DB Link does. It still has its issues though.I'm retired, if you don't like it, go around!
Comment
-
Originally posted by hypnox1 View PostI suppose I should warn you that the access side has a lot of limitations and nuances (read as annoyances). When you first build your access export every category has its own table and nothing is linked together. From there you have to manually build links between tables, if needed. Stuff like links and formulas (can't remember if that is what they are called in access) get broken every time you export to access. It's almost best to just work with it the way it gets exported, which is a real pain sometimes.
Those issues may have been fixed for the 2011 release as I have not used it since 2010. I have since switched to using the Revit Data Transfer Tool which works exclusively with xls files but doesn't seem to have as many problems as DB Link does. It still has its issues though.
-Export the files from revit
-Open in Excel and open a new excel document, call it Dummy or whatever you like.
-Link the new excel document to the exported files from revit. In excel, go to cell A1, simply type "=" and switch to the document to which you want to link and select cell A1.
- It will show something like ='Export$A$1' (with export being the name of the exported revitfile). Remove both the $-signs.
- In the new file, stretch out the the cell using the little black quadrant in the lower right corner, first stretch to all columns. Let go, regrab and stretch to all rows (it won't let you stretch in two directions simultaniously)
Now you have a link to the exported file from revit. The trick is this: close all exported files from Revit, save and close the new file. Change something in Revit, re-export, open the exported file in Excel first and then open the Dummy-file. All changes will update automatically.
Few drawbacks:
- You need to have some breating room in your linked cells. Excel doesn't automatically update the range of links. So if you link to a export which contains 10 rows of data, alter that in Revit to being 15 rows, the last 5 rows will not show in your Dummy. What I normally do is this: have a link to at least 2 blank rows of data. You will get 2 rows of 0's in Dummy. If it's less, you know you will have to adjust the link range.
- Make sure you have the auto-update on startup OFF. Update manually and only if the exported are also opened within Excel. If not, you could end up with manually cancelling all attempts to update from excel.
Pro:
This works with delimited exports too. So you can use the "normal" schedule export from Revit.
Like I said, I haven't tried this with Access but I do know you can link cells in the same way as you do in Excel. So it should work (without any addons or extra costs).
I could mock up a dummy for you if I have more time (on a deadline) and if you're interested to play around.Martijn de Riet
Professional Revit Consultant | Revit API Developer
MdR Advies
Planta1 Revit Online Consulting
Comment
-
Originally posted by mdradvies View PostI could mock up a dummy for you if I have more time (on a deadline) and if you're interested to play around.I'm retired, if you don't like it, go around!
Comment
Related Topics
Collapse
-
Hello, I installed necessary drivers and DB Link gives me the option to _Select New Connection_ under MS Access 2007 tab.
First problem:...-
Channel: Structure - Interoperability
February 4, 2020, 09:13 AM -
-
Hey all,
I've been considering exploring some of Revit's more "advanced" features and I figured that the DB Link would be a good...April 18, 2011, 06:32 AM -
Hey guys,
Sorry I am kind of a newbie and if I am posting this in the wrong section.
I am trying to get the Revit...-
Channel: Third party Add-Ins, API and R&D
January 22, 2015, 08:44 AM -
-
Hello,
I don't know whether DB link is still used these days. Finally I had some time to learn ACCESS and the idea of Data Bases, so I wanted...-
Channel: Third party Add-Ins, API and R&D
May 29, 2021, 08:28 AM -
-
The incompatibility between 32 bit Microsoft Office database systems and 64 bit Revit program architecture have been causing headaches for a while, but...
-
Channel: Blog Feeds
January 17, 2015, 03:45 AM -
Comment