I am trying to automate gateway to import an XLS spreadsheet from an accounting program that we export to XLS. It works as expected using the GUI, but when I try it from the R> it creates the table correctly, but then throws an access violation (sometimes) and a 2442 error "LIKE clause accepts only a constant with a TEXT or NOTE data type. Compiled version just throws an access violation.
I created a simple XLS file with simple data and still get the error. One of many command lines that cause the error for me: R>gateway import XLS .vfilepath create t_checks Any ideas what I am doing wrong? I have never attempted automating gateway before. Kenny Camp
