Link to home
Create AccountLog in
Avatar of gotiva
gotiva

asked on

How to run Monarch Model

I have a MS Excel file with the data that needs to be loaded into MS Access database through MONARCH.
My problem is that I dont know how to run Monarch. I have Monarch Model, a file with .mod extension but I can not open it and got no clue how to run it.
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Hi gotiva,

Checkout http://tinyurl.com/68jmjx


Good Luck!

Gary
Avatar of gotiva
gotiva

ASKER

Thank you Gary for your quick reply,
But the link you sent me doesnt show how to open a file with .mod extension which contains Monarch model that I should use to load data from MS Excel into MS Access database.
SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of gotiva

ASKER

I tried to contact Datawatch customer support but I was told that .mod extension file probably contains Monarch model not supported by Datawatch anymore.
Does anyone else has any suggestion how to execute this application?
Thank You!!
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
So I'm going to assume you have Monarch.  You will want to open up the Excel file first in Monarch by File -> Open Database, then the model in the same pop-up you get when opening up the Excel file.  You will probably then have to change the view to Table to see what the model does to your file.  After you have done that, click on Export in the toolbar and chose Access as the filetype.
The whole process from Monarch automation thru loading Excel into tables can be done easily from VBA in Access without touching the Monarch gui.