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: stephanie smith
  Where is stephanie smith?
 billingham
 United Kingdom
 stephanie smith
 Tags
Subject: RE: VFP 8 and Excel
Thread ID: 269091 Message ID: 269113 # Views: 23 # Ratings: 0
Version: Visual FoxPro 8 Category: Helpfiles
Date: Friday, July 16, 2010 12:14:58 PM         
   


If you are able to automate "Import External Data" from the "Data" menu, you can import VFP8 dbf. I did that, but manually, some time ago. You need to have the "MS vfp driver" installed (you should have it, at least on your development machine).

> > Hi
> > I didn't read your macro, but if I understood well, you may avoid such problems by converting the DBF to a older format. If I remind well, I did once convert to FOX2X or FOXPLUS, then it worked.
> >
> >
> >
> >
> > Regards
> > Samir
>
> Thanks for the replies!
>
> The excel I'm currently using is 2000, but I've tried from my home PC on excel 2007 and it does exactly the same thing, seems to be the DBF file rather than excel!
>
> And problem with changing the .dbf to a previous format is that we have 1000 up on 1000 of dbf files which is a pain, and I don't think the director will go for that either unfortunatly!
>
> Thanks again.



Regards
Samir

ENTIRE THREAD

VFP 8 and Excel Posted by stephanie smith @ 7/16/2010 11:37:43 AM
RE: VFP 8 and Excel Posted by Mike Gagnon @ 7/16/2010 11:58:58 AM
RE: VFP 8 and Excel Posted by Samir H. @ 7/16/2010 12:02:10 PM
RE: VFP 8 and Excel Posted by stephanie smith @ 7/16/2010 12:08:25 PM
RE: VFP 8 and Excel Posted by Samir H. @ 7/16/2010 12:14:58 PM
RE: VFP 8 and Excel Posted by Mike Gagnon @ 7/16/2010 12:16:58 PM
RE: VFP 8 and Excel Posted by Nivedita Joshi @ 7/16/2010 12:18:18 PM
RE: VFP 8 and Excel Posted by Anders Altberg @ 7/16/2010 1:42:07 PM