Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tony Vignone
  Where is Tony Vignone?
 St Augustine
 Florida - United States
 Tony Vignone
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: Office 2010 files crash VFP
Thread ID: 395524 Message ID: 395545 # Views: 38 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Wednesday, January 15, 2014 7:32:12 PM         
   


> > In the past, I was using Windows XP and Office 2003
> >
> > I had no trouble with either
> >
    IMPORT FROM (xlfile) type XLS

> > or
> >
    APPEND FROM (xlfile) type XLS

> > Then I move to Windows 7 and installed Windows 2003.
> > Still, everything worked OK.
> >
> > Then I installed Windows 2010. I opened an Excel file and saved it as "Excel 97-2003 Workbook (*xls)"
> >
> > Then, whenever I use IMPORT or APPEND, VFP crashes with the following (I also tried XL5) ...
> >
> >
> >
> >
> > So, I am continuing to use Office 2003 but in April it will no longer be supported by Microsoft.
> > I would really like to migrate to Office 2010.
> >
> > Any suggestions?
> >
> > Tony
>
> I have never seen this type of crash. Can you email me a file which makes VFP crash, so that I can test it myself?
>
> Are you forced to use xls format? With VFP, xl5 has proved to be a better format. Also with Excel 2007 and 2010 you can use xlsx. To read a xlsx file into VFP, you can use Craig Boyd's tool which you find at http://www.sweetpotatosoftware.com/spsblog/2008/09/30/UsingExcel2007FileFormatsInVFP90.aspx.
>
> There's a fine line between helping and adding to the confusion.
>
> How to create sample data

I decided to use Cecil's solution rather than Boyds. By the way, Boyd has also discovered that XLS file do not work with Office 2007 and higher.

Tony

ENTIRE THREAD

Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 5:51:20 PM
RE: Office 2010 files crash VFP Posted by Koen Piller @ 1/15/2014 6:01:38 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:28:06 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 6:04:18 PM
RE: Office 2010 files crash VFP Posted by Koen Piller @ 1/15/2014 6:30:29 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 6:37:14 PM
RE: Office 2010 files crash VFP Posted by Cecil Champenois @ 1/15/2014 6:53:22 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 6:57:03 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:33:06 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:32:12 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/15/2014 7:48:08 PM
RE: Office 2010 files crash VFP Posted by Tore Bleken @ 1/15/2014 8:12:11 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/16/2014 12:51:19 AM
RE: Office 2010 files crash VFP Posted by Jun Tangunan @ 1/15/2014 11:51:14 PM
RE: Office 2010 files crash VFP Posted by Tony Vignone @ 1/16/2014 12:50:31 AM