Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Barak Ros
  Where is Barak Ros?
 TLV
 Israel
 Barak Ros
 Tags
Subject: RE: import
Thread ID: 233337 Message ID: 233338 # Views: 42 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, July 01, 2009 5:06:51 PM         
   


> hi all
> I am trying to import xls file
>
local lcXlsfile
> lcXlsfile=GETFILE('XLS', 'Browse .XLS:', 'Browse', 1, 'Browse')
> 
> DO CASE
>    CASE EMPTY(lcXlsfile)
>       RETURN
>    OTHERWISE
>       IMPORT FROM lcXlsfile TYPE XLS SHEET "rptnewpos_csmo"
>       BROWSE
> ENDCASE

>
> I get an error that the file does not exists
> how can I solve it???
>
> maybe needs
>
IMPORT FROM &lcXlsfile TYPE XLS SHEET "rptnewpos_csmo"

>
> ????
> TIA
> Barak

IMPORT FROM (lcXlsfile) TYPE XLS SHEET "rptnewpos_csmo"



-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.



COMPLETE THREAD
import Posted by Barak Ros @ 7/1/2009 4:59:50 PM
RE: import Posted by Borislav Borissov @ 7/1/2009 5:06:51 PM