Thanks a lot, Xypron. That worked perfectly. Aly
----- Original Message ----- From: "glpk xypron" <[email protected]> To: [email protected], [email protected] Sent: Thursday, April 29, 2010 1:39:39 AM GMT -05:00 US/Canada Eastern Subject: Re: [Help-glpk] Connecting Excel 2007 to GLPK Hello Aly, > I'm trying to connect Excel 2007 to GLPKthrough ODBC, but I have a > problem. > > I define my file in the driver Microsoft Excel Driver (*.xls, *.xlsx, > *.xlsm, *.xlsb), but then when I put that in my GLPK code, I get the > message "string literal too long". strings in GMPL are limited to 100 characters. You can use a file DSN. Create a file with a content like: [ODBC] DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) DBQ=.\sudoku.xls File DSNs can also be created using tab "File DSN" in %WINDIR%\system32\odbcad32.exe Change your table statements to use the file DSN, e.g. table ta {(i, j) in {i1 in 1..9} cross {i2 in 1..9}} OUT 'ODBC' 'FileDSN=.\sudoku_excel.dsn;READONLY=FALSE' # ADO does not support deleting from Excel 'UPDATE [sudoku_solution$] SET VAL = '''';' 'UPDATE [sudoku_solution$] SET LIN = '''';' 'UPDATE [sudoku_solution$] SET COL = '''';' 'UPDATE [sudoku_solution$] SET ID = '''';' 'INSERT INTO [sudoku_solution$]' '(ID, COL, LIN, VAL)' 'VALUES(?, ?, ?, ?);' : id ~ ID, i ~ COL, j ~ LIN, (sum{k in 1..9} x[i,j,k] * k) ~ VAL; Best regards Xypron -- GRATIS fur alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 -- 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
