Excel solver via access/vba

[a***@gmail.com]

I am trying to use the solver functionality via Access.

I have dataset in Access.I need to run an optimization on that data using the excel solver. I then need to transfer the results back into Access Automatically.
Any Example/Idea??

[John W. Vinson]

Post by a***@gmail.com
I am trying to use the solver functionality via Access.
I have dataset in Access.I need to run an optimization on that data using the excel solver. I then need to transfer the results back into Access Automatically.
Any Example/Idea??

I am not at all skilled in Access-Excel interfacing, but some folks are.
Unfortunately they no longer hang out in this newsgroup; Microsoft killed it
several years ago.

Newsgroups, however, are like zombies - they cannot die until all news servers
stop carrying them. However, this one has very little traffic; most of the
volunteers have gone elsewhere.

See my .sig for some hopefully more fruitful areas to explore your question;
and good luck with it.