Hi All, I hope you are doing well. Your previous help concerning the details of connecting GLPK/MathProg to Access worked greatly.
Now, do you mind writing me (and all users) detailed instructions and an example of how to connect it to Excel (either through that csv or dbf, or whatever) in order to be able to get data from Excel and send variable values back there? I use GLPK_4_41.dll and glpsol.exe. Your help is greatly appreciated. Best, Aly ----- Original Message ----- From: "Noli Sicad" <[email protected]> To: "Aly Megahed" <[email protected]> Cc: [email protected] Sent: Tuesday, February 9, 2010 6:04:43 PM GMT -05:00 US/Canada Eastern Subject: Re: [Help-glpk] Connecting GLPK to Excel or Access Aly, I suppose you have downloaded the glpk-4.42 tarball and GUSEK IDE for GLPK/GMLP (MathProg). If not yet. I think you should download it. http://ftp.gnu.org/gnu/glpk/ http://sourceforge.net/projects/gusek/ Are you into programming C/C++, python, java, etc. using GLPK API thru library (*.dll) to create your model, or more into modelling? For modelling, use MathProg (GMPL) with GUSEK IDE. MathProg supports to csv, dbf and sql tables. Have a look at the examples in glpk-4.42 tarball especially csv, dbf and sql. You can easily create csv and dbf tables using Excel. For Access, you can SQL using ODBC connection. Read all the postings - Re: Excel Access here: http://www.mail-archive.com/search?q=excel+access&l=help-glpk%40gnu.org Welcome to GLPK. Regards, Noli On 2/10/10, Aly Megahed <[email protected]> wrote: > > Hi All GLPK users, > > I'm a new user for GLPK, and I really need to connect it to either Excel or > Access. I want to take the inputs (parameters values) from either Excel or > Access, and send the model output to either Excel or Access. > > Is there a clear way how to do that? I read there is some .dll that connects > to Access, but I couldn't find it, or find instructions on how to clearly > use it. > > Could you please provide me with any help in that? i.e. a clear way and > instructions on how to connect GLPK to Excel and/or Access? > > Thanks, > > Aly > > -- > PhD Student > Vice President, Egyptian Student Association in North America, Georgia Tech > Chapter > > Rm. 407 Main Building > H. Milton Stewart School of Industrial and Systems Engineering > Georgia Institute of Technology > 765 Ferst Dr., NW > Atlanta, Georgia 30332-0205, USA > > > > > > > _______________________________________________ > Help-glpk mailing list > [email protected] > http://lists.gnu.org/mailman/listinfo/help-glpk > -- PhD Student Vice President, Egyptian Student Association in North America, Georgia Tech Chapter Rm. 407 Main Building H. Milton Stewart School of Industrial and Systems Engineering Georgia Institute of Technology 765 Ferst Dr., NW Atlanta, Georgia 30332-0205, USA -- PhD Student Vice President, Egyptian Student Association in North America, Georgia Tech Chapter Rm. 407 Main Building H. Milton Stewart School of Industrial and Systems Engineering Georgia Institute of Technology 765 Ferst Dr., NW Atlanta, Georgia 30332-0205, USA _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
