Inventor iLogic Function To Pull Data From An Access Database

[Anonymous]

Split from solved post how can i get iproperty values filled in by reading an excel file to new thread for clarity.

Is there an iLogic function, similar to the above code, that can pull data from an Access database?

GoAccess.DisplayAlerts = False

DESC = GoAccess.CellValue("//myDrive/Projects/iTEST.xlsx", "DATA", "A2")

iProperties.Value("Project", "Description") = DESC

InventorVb.DocumentUpdate() 

GoAccess.Close

Obviously there would be additional formatting to dig to the cell you want in a table etc... but can it be done?

Also - is there a reverse process to this such that additional data that was typed in an iPart field could then be pushed back into the database (or Excel)?

[chandra.shekar.g]

@Anonymous,

Hoping that article in below blog link may be helpful.

https://adndevblog.typepad.com/manufacturing/2017/08/connecting-microsoft-access-via-inventor-ilogic.html

Thanks and regards,