Karen, will this work for CSV and well as XLS. I have tried the snippet of code below and am having some trouble still. The other programmer says his program creates a file like I was originally receiving, however, I have yet been able to get his files to load regardless of what I do.
Thanks Gary _____ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, December 28, 2009 5:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: XLS Load Error Message Looks like you got the same kind of file that I had to deal with! Here's what I had to do to get it to load. The code is on my other computer so I don't have it handy, but here's what I think it did: OUTPUT FRename.bat WRITE 'TYPE filename.xls > filename.TAB' OUTPUT SCREEN LAUNCH FRename.bat||W GATEWAY IMPORT TAB filename..... etc Karen Not so much in complaining about the loading but your point about the Unicode style is interesting. It seems if I open and save the file, the defaults through EXCEL list it as a Unicode file rather than EXCEL. I actually did not pay much attention to the process until your statement regarding the Unicode. Thanks Gary
