james.charles.burgess
2009-07-23, 04:04 PM
I'm trying to create room data sheets exported from revit as an odbc database to microsoft access.
As seen in the attached screen dump jpg - I have all the data in access... Furniture types etc. - however can't make a 'query' work which allocates all the furniture to rooms and schedules it out. is this the right way to do it)
The pdf RDS attached is one which we have created from revit to excell (using tab associations - to keep it somewhat coordinated) and gives an idea of what we are attempting to achieve.
Can anyone provide a step by step process as to how I might be able to do this? Or a steer in the right direction.
As an aside, is there a way that the sheet information can be exported to access as well?
cheers.
As seen in the attached screen dump jpg - I have all the data in access... Furniture types etc. - however can't make a 'query' work which allocates all the furniture to rooms and schedules it out. is this the right way to do it)
The pdf RDS attached is one which we have created from revit to excell (using tab associations - to keep it somewhat coordinated) and gives an idea of what we are attempting to achieve.
Can anyone provide a step by step process as to how I might be able to do this? Or a steer in the right direction.
As an aside, is there a way that the sheet information can be exported to access as well?
cheers.