Yes, it actually is the first time I've tried to do a Gateway Import with Excel. Hard to believe I haven't had to do this before now with any of them!
The client (ex-developer Jeff Ward, you know him ...) is on 7.5, don't think he has plans on going to 7.6. I'm assuming from your answer that what I'm trying to do doesn't work in 7.5 but does in 7.6. I'll test it here with my copy of 7.6 just so I can tell him what he would have to do if he wants old worksheets... Karen > >In 7.5, can you no longer do a Gateway Import XLS of a spreadsheet that > >is saved as an "Excel 4.0 Worksheet", rather than a workbook? I got a > >spreadsheet, brought it up in Excel, do a Save As and see that it's > >currently saved as Excel 4.0 Worksheet, but didn't re-save it. When I > >try to do a Gateway Import I get a message: > > > >"The file c:\temp\test.xls exists but is not a storage object" > > > >That would kinda suck because one of this client's branches who will > >be sending in spreadsheets doesn't have a newer version of Excel. > > > When was the last time you tried using the Gateway Import with Excel? > > Is this the first time you are exploring this feature in R:BASE 7.5? > > Try the FREE evaluation version of R:BASE 7.6 for Windows and see what > you get. http://www.rbase.com/evaluation/ > > Very Best R:egards, > > Razzak.
