Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: vinod kabdal
  Where is vinod kabdal?
 Delhi
 India
 vinod kabdal
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: import data from excel 2007
Thread ID: 187647 Message ID: 187690 # Views: 29 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Tuesday, August 05, 2008 12:41:15 PM         
   


Dear Expert

Office 2007 is not support in VFP. You can import in only old xls format.

Thanks

> > Dear Expert
> >
> > i have a excel file which is save in office 2007
> > when i import this excel file in database the error occur
> >
> > " microsoft excel file format is invalid "
> >
> > my command line is
> >
> > IMPORT FROM w:\ppic\kkpaper TYPE xls
> >
> > but when i use file save in microsoft excel 2003
> > it run correct
> >
> > can any body help how i use file save in excel 2007
> >
> > thanks and regards
> >
> > Nadeem
>
> You can't.
> if you want to import a Excel 2007 file you must save it AS 5.0/95 Workbook.
> Any other format will bomb.
> Other way is to use ADO to import data.
>
> Check Message ID: 153776
> -----------------
> 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 data from excel 2007 Posted by Syed Nadeem Shibli @ 8/5/2008 9:00:13 AM
RE: import data from excel 2007 Posted by Borislav Borissov @ 8/5/2008 9:06:46 AM
RE: import data from excel 2007 Posted by vinod kabdal @ 8/5/2008 12:41:15 PM
RE: import data from excel 2007 Posted by Yousfi Benameur @ 8/5/2008 12:12:36 PM