ODBC is not available (help)

[Fei Xie]

Hi,

I have problems in using ODBC with 64-bit AMPL. I was trying to write
a table to an excel file, but the AMPL told me that ODBC is not
available. I have put the file " ampltabl.dll" in the folder.

Here is my code:

table AAA OUT "ODBC" "files/bbb.xlsx" :
[words], rank_first, rank_second, rank_third, {i in words}
rank_first[i]/rank_second[i]~aaa;
write table AAA;

Here is the output:
Error at _cmdno 4 executing "write_table" command
(file files/letter_trialforoutput.mod, line 30, offset 1077):

Error writing table AAA with table handler odbc:
ODBC is not available.

Can anyone help me to find the problem? Thanks a lot. By the way, I
have heard that ODBC is not consistent with 64-bit AMPL. Is that
true?

Best wishes
Fei

[Robert Fourer]

The first thing to check is that you are using the 64-bit version of
Microsoft Excel. If you try to use 32-bit Excel with 64-bit AMPL then you
will get this error message.

Unfortunately Microsoft makes it difficult to use 32-bit Office products
with 64-bit AMPL (or 64-bit Office products with 32-bit AMPL). We're
working on a way around this but expect some delay before it is available.

Bob Fourer
4...@ampl.com

[Fei Xie]

Thanks, Bob.

Fei