Export to Excel or Access Database Does Not Work

Export to Excel or Access Database Does Not Work

Anonymous
Not applicable
3,484 Views
22 Replies
Message 1 of 23

Export to Excel or Access Database Does Not Work

Anonymous
Not applicable

I have been trying to export a Revit model to an Excel or Access file as database. I use File-Export-ODBC path. The program gives errors or crashes. I have posted similar questions earlier, but no response; maybe the question was not clear.

 

My Revit is version 2019 with the latest updates installed. Windows 10 1809 October Update installed. Both are 64 bit.

 

My question is:

1. Does  export to Excel or Access database work in Revit 2019, or does it have a bug?

2. What other ways -that for sure works- can I use to export to a database, preferably as an Excel or Access file?

0 Likes
3,485 Views
22 Replies
Replies (22)
Message 21 of 23

ToanDN
Consultant
Consultant
It gives you an error at which step? The one you show Save As to Access 2000 or 2003 format from Access 2016? As I said, there should be no Save As involved.

There are no bugs. I can do it every time without hick ups from Revit 2015 to 2019. Same steps for all of them.
0 Likes
Message 22 of 23

Anonymous
Not applicable

@ToanDN

 

Revit DB Link --> MS Access 2007 Tab --> Export --> [Select Database Window] File Name: *I give file name here*, Save as Type: MS Access Databases (*.mdb) --> Click Save --> An unrecoverable error occured. --> Send a crash report to AutoDesk.

 

Funny, because this just happened under Revit 2016, which was fine 10  mins ago.... Pretty frusturating...

 

Annotation 2018-11-08 103955.jpg

 

Difficult to tell where the problem is...

0 Likes
Message 23 of 23

ToanDN
Consultant
Consultant
Choose New Connection the first time you do it.
0 Likes