AutoCAD Plant 3D P&ID data Mapping with Excel

[quaglia.l]

Hi;

I'm trying the new features relevant to data mapping. My goal is to map some P&ID object properties with an Excel file.

To do this I'm using MS ODBC Data Sources 64 bit. After several tests, I can connect the driver and the relevant Excel file, but the reference table drop down menu is empty. 

Attache some screeshot.

Could someone help me?

Thank a lot!!

[Michiel.Valcke]

some extra 'extended properties' are necessary to make it work in the old PLANTDBXMANAGER. I suppose this will be the same. Although most people would convert it to an Access db file to make it easier.

https://www.autodesk.com/support/technical/article/caas/tsarticles/ts/1uStQ3uA3tsC6uQS3DlGAi.html

[quaglia.l]

Thank you for the answer, but it is not so clear for me how to set this "extended properties". So I assume that this new mapping feature cannot work properly with Excel.

[Michiel.Valcke]

try adding it to the connection string:

[quaglia.l]

Which is the entire syntax of the Connection string? Thank you

[Michiel.Valcke]

That depends on the file and it's location, use the build button to make the connection string, copy it to notepad. Test the original, if it doesn't work, add the extended properties as shown in the link.

[quaglia.l]

Thank you again for your help; but unfortunaltely I tried severa strings without succed.

DSN=Excel Test;DBQ=C:\AAAA\ProvaLink.xlsx;DefaultDir=C:\AAAA;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;Extended Properties="Excel 12.0 Xml;HDR=YES";Persist Security Info=False

DSN=Excel Test;DBQ=C:\AAAA\ProvaLink.xlsx;DefaultDir=C:\AAAA;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5; Excel 12.0 Xml;HDR=YES

If you have any other hints, I appreciate it.