Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Barak Ros
  Where is Barak Ros?
 TLV
 Israel
 Barak Ros
 Tags
Subject: import
Thread ID: 233337 Message ID: 233337 # Views: 33 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, July 01, 2009 4:59:50 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



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