home bbs files messages ]

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