# Existing Excel or Access Database to Revit?

**URL:** <https://forum.dynamobim.com/t/existing-excel-or-access-database-to-revit/4096>\
**Category:** Packages\
**Created:** [May 20, 2016, 7:50pm UTC](https://forum.dynamobim.com/t/existing-excel-or-access-database-to-revit/4096 "2016-05-20T19:50:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kdrakeDYN](https://avatars.discourse-cdn.com/v4/letter/k/cab0a1/32.png) [@kdrakeDYN](https://forum.dynamobim.com/u/kdrakeDYN)\
**Post date:** [May 20, 2016, 7:50pm UTC](https://forum.dynamobim.com/t/existing-excel-or-access-database-to-revit/4096/1 "2016-05-20T19:50:48Z")

</div>

Hello, I am new to Dynamo, and was looking to link an existing database (either Access or Excel) to an existing Revit file. Is this possible? I have only seen examples where Excel is exported out of Revit, updated, then imported back into Revit. Thank you

---

<div class="post-metadata">

**Author:** ![Chris\_Melander](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chris_melander/32/8638_2.png) [@Chris\_Melander](https://forum.dynamobim.com/u/Chris_Melander)\
**Post date:** [May 20, 2016, 8:26pm UTC](https://forum.dynamobim.com/t/existing-excel-or-access-database-to-revit/4096/2 "2016-05-20T20:26:18Z")

</div>

Hello! Welcome to the forum! What information from the excel file are you attempting to transfer into Revit? There are many examples of taking information that is stored in an excel file and using it within Revit. Say for example you are trying to change parameters of a certain element with information that has been stored within excel. You could setup your graph to look something like this:

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/2X/0/0ac214c3034d053eafbb86628ca0a403f873a1c0.png)

Does that help?

---

<div class="post-metadata">

**Author:** ![kdrakeDYN](https://avatars.discourse-cdn.com/v4/letter/k/cab0a1/32.png) [@kdrakeDYN](https://forum.dynamobim.com/u/kdrakeDYN)\
**Post date:** [May 26, 2016, 1:33pm UTC](https://forum.dynamobim.com/t/existing-excel-or-access-database-to-revit/4096/3 "2016-05-26T13:33:39Z")

</div>

Hi Chris, thanks for the response. We have an existing Revit file from 2012 (now upgraded to 2015), with aprx. 2,000 rooms, and an existing Access data base. The Revit is driver for geometry (area) and Access is driver for most other data (name, department, etc., about 10 parameters) Back in 2012, we were exporting data from Access to Revit, to update the Revit file. This was a cumbersome process run by our IT dept. We were hoping that Dynamo would be a fairly simple way to connect the two files, either directly or through Excel. Do you know if anyone is linking Access to Revit?

---

<div class="post-metadata">

**Author:** ![Andrew\_Hannell](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/andrew_hannell/32/103315_2.png) [@Andrew\_Hannell](https://forum.dynamobim.com/u/Andrew_Hannell)\
**Post date:** [May 29, 2016, 10:51pm UTC](https://forum.dynamobim.com/t/existing-excel-or-access-database-to-revit/4096/4 "2016-05-29T22:51:49Z")

</div>

MSAccess is a bit of a problem, due to issues with 64 bit drivers.

For the Access part, you would be better off converting the database to SQL (using the free ‘SQLExpress’ version of SQL server)  
Refer:

> [@Pushing a formula to Excel from a Dynamo String](https://forum.dynamobim.com/t/pushing-a-formula-to-excel-from-a-dynamo-string/4047/20):
>
> @Jason_Parker thanks for leaving a comment on my blog (actually 3). I mentioned this before. bumblebee currently only supports Dynamo 0.9.2. I am working on an update for 1.0.

> [@Revit Dynamo access Database](https://forum.dynamobim.com/t/revit-dynamo-access-database/3324):
>
> Hello, i’m new to Dynamo and this is my first attempt to make a connection to an access database trough an OLEDB connection. But nothing works. Can anyone tell me what i’m doing wrong here. Tanx

You can of course also use ‘DBLink’ [Autodesk App Store](https://apps.autodesk.com/RVT/en/Detail/Index?id=5072854987084642377&appLang=en&os=Win64)

Andrew
