You can't. It's either MS Office Excel ... or nothing.
But if you can find a way, you will make a lot of people very happy.
Thanks a lot.
If Dassault Systems brings a permanent solution, "A lot of people" will more happy
I believe that before requesting SolidWorks to provide the design tables with the ability to work with applications other that Microsoft Excel, will be a lot better to request SolidWorks to enhance the present design tables functionality based on the Microsoft Excel application, with things such as:
- The ability to use design tables on any sub-assembly and component (part level), having values on those tables linked to values on external files (Excel) and have hability to "update" all those tables by executing a single comand (such as "rebuilt model with design tables update").
- The ability to maintain the referencial integrity between desing tables and linked external files when a project (model) is copied to a new directory to generate a new model with different input values on the product configurator files (external files driving input values on design tables), or an easy way to edit the path of those links when required.
I believe that we will be much better is we get a "design table" functionality that realy works to drive a 100% parametric assembly that if we get the possiblity to use 200 different applications, but with very "limited" or incomplete functiuonality.
I agree, probably for very different reasons. I do make fixed configurations with design tables, and I really want them all to update automatically. I want to edit all configurations of an assembly component, no matter which configuration is active. I want to edit a design table from a drawing. As you say, I'd accept fewer options than Excel offers (but then again I don't want to give up those I really need.)
I fail to understant why SW have not improved the functionality of design tables as required to be able to "update" all tables with asingle comand in stead of force the user to open each component, them open the table, close the table, rebuilt the component and do this again and again with every single component (or sub-assembly) that contain a design table. Neither, why they do not add the functionality required to maintain the refeences between linked files (design tables linked to a "master excel file" where you can enter or calculate all the input parameters).
We show to SW back in 2006 the need for this and the power that this will add to the application, not just for us, but for every user, and we also show to them that it can be done with a very simple code (we have done that in our own, however it will be nice if done by SW as part of the program and made available to every user that may need this).
We use the design tables to drive parametric models (call them "dynamic configurations"), however, every one needs this functionality. for example in your case, the design tables are used to define and manage configurations, therefore if you where able to link all those tables to a single source where you can enter your input values, and them open the model and execute a single comand (Update all DT;s and Rebuilt the complete model), even if the process will take a long time (if is done with a simple VB code), you will be able to let the machine work alone, when doing another thing, in stead of being opening 200 parts, operning 200 DT's, entering data on them, and closing all, one after another. Unless you enjoy clicking on the keyboard and using the mouse, this do not make any sense, when by investing some time on enhancing the functionality, SW can save millions of hours of manual work to the users.
Retrieving data ...