Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: madiha saleem
  Where is madiha saleem?
 lahore
 Pakistan
 madiha saleem
 Tags
Subject: RE: open excel file
Thread ID: 288940 Message ID: 288947 # Views: 36 # Ratings: 1
Version: Visual FoxPro 5 Category: Projects and Design
Date: Monday, December 27, 2010 8:00:51 AM         
   


> >
> >
> >
DECLARE INTEGER ShellExecute IN shell32.dll as shellExecute1 ; 
> >   INTEGER hndWin, ; 
> >   STRING cAction, ; 
> >   STRING cFileName, ; 
> >   STRING cParams, ;  
> >   STRING cDir, ; 
> >   INTEGER nShowWin
> > cFileName =  'c:\temp\test.xls'
> > shellExecute1(0, 'open', cFileName,'', '', 1)
> > 

> >
> > Regards
> > Samir
>
> thank you samir but i need more help... can u plz tel me how can we read data from this excel file means read data from excel file and write this to VFP table
>
> Regards,
> madiha saleem

Hi Madiha
Check following in help:
APPEND FROM ... TYPE XL5 / XL8
IMPORT FROM ... TYPE XL5 / XL8


Regards
Samir

ENTIRE THREAD

open excel file Posted by madiha saleem @ 12/27/2010 7:14:48 AM
RE: open excel file Posted by Samir H. @ 12/27/2010 7:31:56 AM
RE: open excel file Posted by madiha saleem @ 12/27/2010 7:42:27 AM
RE: open excel file Posted by Samir H. @ 12/27/2010 8:00:51 AM