Connecting to a database

Hi,

I have a situation in which all my input data is in a MS Access database file and I need to import this data to build my model.

I came to know that there are ways to link MS Access to Flexsim, which can populate all the Flexsim-tables directly.

Need some help in understanding the basics of Access-Flexsim linkage. I went through the forum, but not much was available over there on this issue.

Regards,
Naren Nataraj.

It is pretty straightforward:
1 create an ODBC connection to your database
2 use all the db... commands to access your database and use the ODBC name you specified when you created your ODBC connection.

Thank you for your reply. I was trying to do the same but wasn't able to. Can you explain me the first point in a detail, as in How do I exactly connect a MS Access Database say "Sample.mdb" saved on my Desktop to the FlexSim model?

Please check out the dbopen command and do some google searching. It is not that complicated:

This is how you create an odbc connection:
http://www.ehow.com/how_6503661_crea...-database.html

or with some pictures:
http://www.openoffice.org/FAQs/ms-access/ms-access.html

Suppose you have named your ODBC connection "MyDB" then start Flexsim and you can open your database with: dbopen( "MyDB", "select * from ATable", 0);