Posted by Grant Foraker on September 17, 2004 at 10:09:46:
In Reply to: Try this Grant...> posted by Tom Fulton on September 17, 2004 at 05:37:51:
Tom:
Thanks for the response and the email. I tried the odbcdrv you sent with no luck.
I then changed the MAP to ...
EmployeeMap: FORMAT _
"EmplVaca.CEMPNO, 5;";_
"EmplVaca.CENAME, 25;";_
"EmplVaca.CUNION, 1;";_
"EmplVaca.CSVCYRS, 2.0;";_
"EmplVaca.C2080HRS, 6.2;";_
"EmplVaca.CVACYRS, 2.0;";_
"EmplVaca.CINDEX, 8.6;";_
"EmplVaca.CALCAVAIL, 10.6;";_
"EmplVaca.CURRAVAIL, 10.6"
No luck here either. Not sure how I can debug any further. I'm at the offending statement. A READ that gives an E29.
Could there be something hidden in the XLS file. It was cut and pasted from a very large and complicated XLS file by my customer.