REVIT DB LINK TO MS ACCESS & EXCEL PRICING SHEET

[CADDaddy]

Hi,

I have a good idea of what Im trying to do, but I'm not sure if I'm going about it the right way. I recently downloaded the Revit DB Link Add-in. I would like to export all schedule data into Access to be able to work with my estimating team. From my esimating team, I have a MS Excel spreadsheet with constantly updated prices/costs. I want to be able to link the costs/pricing to my Revit Schedule's cost column. I have no problem exporting my MS Access tables to Access from revit. I have no problem linking or importing an excel sheet into Access... I am LOST when it comes to linking the pricing form the excel sheet to the pricing in the Revit data... This is probably more of a MS Access question, but any help as to HOW i should do this, or any other ideas of how to even go about this process would be greatly appreciated!

Thank you

[cliff collins]

See if the attached instructions help.

cheers

[Brandon_Pike]

If you have both the Revit Building Data and the Cost data in MS Access but in different tables, you will need to write a query to bring the two together in one table. For this to work, there will need to be at least one piece of data or data field that is common between both tables, such as a Material Name, CSI Number, or Uniformat Classification, etc.

[DaveP]

How odd. I just asked this same question elsewhere this very morning:
Once upon a time, you could not use RDB Link with 64-bit Windows.
Has that problem been fixed?
Seems to me it had to do with a Windows driver or something.

I have something I'd like to write an API program for, but I'm never going to learn C#.
Probably could do it in a database, though.