Kenny, It is important to know which version and which update (well maybe just the update). There was a problem with GATEWAY import that was fixed roughly March of this year.
Jan -----Original Message----- From: "Kenny Camp" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 2 Dec 2009 16:25:38 -0600 Subject: [RBASE-L] - Gateway import XLS 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
