Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Exporting schedule to excel using DBLINK

15 ANTWORTEN 15
GELÖST
Antworten
Nachricht 1 von 16
Anonymous
2572 Aufrufe, 15 Antworten

Exporting schedule to excel using DBLINK

Hi,

 

I'm trying to export schedule to excel using DBLINK but the tabs under MS Access 2007 and 2000-2003 are empty. Only ODBC able to selection connection.

 

Pls advise as I am using Microsoft Excel to edit scedule and then link back to Revit 2017.

 

Thanks

 

 

DBLINK.JPG

 

Title edit for clarity: Exporting schedule to excel using DBLINK

15 ANTWORTEN 15
Nachricht 2 von 16
ToanDN
als Antwort auf: Anonymous

If I remember correctly you need Excel 2010 64 bit as the minimum. That was with the last time I used dblink in Revit 2015.

By the way, you don't export just schedules via dblink, but the entire model data. If you only look for a two way export edit import schedules, I would look into Dynamo.

Nachricht 3 von 16
Anonymous
als Antwort auf: ToanDN

Thanks Toan for the info.

 

I definitely wont need to export entire project data, only one schedule but I am not familiar with Dynamo, dont know which boxes required to link to....sigh.

 

I'm using Microsoft Offcie 2016, but I cant select connection to export, not to talk about import.

 

Any solution?

 

 

Nachricht 4 von 16
ToanDN
als Antwort auf: Anonymous

Is it 64-bit version?
Nachricht 5 von 16
Anonymous
als Antwort auf: ToanDN

yes 64

Nachricht 6 von 16
ToanDN
als Antwort auf: Anonymous

Not sure what else to suggest.  I have Access 2010 64-bit and DB Link with the option of export to MS Access 2007 works in Revit 2015-2017.

 

Capture.PNG

Nachricht 7 von 16
Anonymous
als Antwort auf: ToanDN

I'm using Excel, not Access, that's the problem

Nachricht 8 von 16
Magnus.B
als Antwort auf: ToanDN

I'm having the same problem, the MS Access tabs are empty. Do I need to set up a ODBC first? I'm running Revit 2017 and Access 2016. 

 

2017-04-05 07_29_29-Autodesk Revit 2017.1 - [Sheet_ Startvy - WSP - Project1].png

Tags (2)
Nachricht 9 von 16
Anonymous
als Antwort auf: Anonymous

Hello,

 

@Anonymous Why don't you use BIM Link in you need to use excel? 

Nachricht 10 von 16
Viveka_CD
als Antwort auf: Magnus.B

Hi @Magnus.B

 

Please see the articles below:

Forum post HERE

Let me know if this helps!

 

Please select the Accept as Solution button if my post solves your issue or answers your question. 

 

Regards,

 

 

Nachricht 11 von 16
Viveka_CD
als Antwort auf: Anonymous
Nachricht 12 von 16
Viveka_CD
als Antwort auf: Anonymous

Hi @Anonymous, @Magnus.B

 

Just checking in to see if you resolved the issue or you seek more assistance from the community.

Let me know and I look forward to your reply.

 

If you find posts have solved your problem, please click on 'Accept as solution' to help others with similar questions.

 

Thank you,

 

 

Nachricht 13 von 16
Magnus.B
als Antwort auf: Viveka_CD

@Viveka_CD Hi thanks for following up, my organization refuses to use office x64. and as of my understanding Revit 64 bit cannot talk to x86 Access. 

Nachricht 14 von 16
Viveka_CD
als Antwort auf: Magnus.B

Hi @Magnus.B

 

Yes, looks like it.

If Access 2007 x86 is installed on x64 machine, the driver cannot be installed.

Refer to the table HERE for more information.

 

Regards,

Nachricht 15 von 16
Viveka_CD
als Antwort auf: Anonymous

Hi @Anonymous, @Magnus.B

 

For now, I have marked solutions to few workarounds to benefit the community!

 

If you have additional questions, we can continue this thread.

 

Regards,

Nachricht 16 von 16
gmansfield
als Antwort auf: Viveka_CD

Hi, i may have missed it but i dont see a solution for the original question. So maybe this will help as i experienced this today. I have ticked all the boxes;

 

Access x64 (doesnt matter if you install from 0ffice 365 or access standalone.)

 

All i did was download and install the AccessDatabaseEngine_X64.exe (https://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEng...)

 

And it gave me the the [Select a new connection] from the MS Access 2007] tab.

GARY MANSFIELD | bim manager
ckr consulting engineers
johannesburg
south africa

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report