Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.paradox    |    To crash or not to crash, asks Borland    |    9,834 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,646 of 9,834    |
|    Anders to All    |
|    Re: Import from Excel .xls problem    |
|    05 Mar 09 09:29:31    |
   
   From: anders@jREMOVEjonssondata.se   
      
   > BTW, here's the exact code I used (with everything in C:\Temp instead):   
   >   
   > method run(var eventInfo Event)   
   > var dt DataTransfer endvar   
   > try   
   > dt.setSource("C:\\temp\\Feb09.xls")   
   > dt.setDest ("C:\\temp\\Feb09Input2.db")   
   > dt.setDestFieldNamesFromFirst(True)   
   > dt.setProblems ( True )   
   > dt.getSourceRange()   
   > dt.transferData ( )   
   > onFail   
   > errorShow("1")   
   > endTry   
   > errorShow("2")   
   > endMethod   
   >   
   > HTH,   
   > Jim Moseley   
      
   I tried exactly the same and it did NOT work!   
      
   I get an error "Could not read from file"   
      
   I tried another Excel file and got the same - I thought I had been using   
   this w/o problem before but maybe my memory is wrong. I will check some   
   more.   
      
      
      
   Anders   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca