Re: [Help-glpk] Connecting GLPK to Excel or Access

[Noli Sicad]

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 <address@hidden> 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
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-glpk
>