I would like to be able to export a global table to a Microsoft Access database for further analysis. I see that there are a few commands around ODBC databases... Are there any examples of information being exported to MS Access or a listing of the relevant FlexSim commands that I can learn from.
Hi @William Proctor,
This tutorial is a good introduction on using ODBC in conjunction with FlexSim. It uses MySQL as the database back-end, but the principles will be the same for Access. It is a good demonstration of finding the right ODBC driver and getting things configured properly so that the communication works (focus on steps 14 and on if you're not going to actually do the tutorial yourself).
Once you have the ODBC driver in place, and you have configured an ODBC data source in Windows, FlexSim can query against the data source, allowing you to call SQL commands on the database to, for instance, export your global table into Access using INSERT commands.
It is easier to export a global table to excel sheet and next to Microsoft access database.
9 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
