Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
RE: QUERYING VFP DATABASE USING ACCESS 2007
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: Jim Lloyd
  Where is Jim Lloyd?
 Hove
 United Kingdom
 Jim Lloyd
 Tags
Subject: RE: Querying VFP database using Access 2007
Thread ID: 204753 Message ID: 204802 # Views: 28 # Ratings: 0
Version: Not Applicable Category: ODBC, ADO and OLEDB
Date: Monday, November 24, 2008 12:50:53 AM         
   

> Cetin,
>
> I can get the data into Excel and then import the data into Access, but I'll need to open the Excel file every time I want to refresh the data, which is awkward.
>
> I've successfully managed to connect in Excel using the OLEDB, what advantages does it have over ODBC?
>
> I'll give the SQL server express route a shot.
>
> Thanks for the advice,
>
> Jim

The one and biggest advantage VFPOLEDB driver can work with any version of foxpro data files from foxbase to VFP9 (ODBC driver OTOH is not updated after version 6 and doesn't recognize newer formats).

Cetin Basoz



COMPLETE THREAD
Querying VFP database using Access 2007 Posted by Jim Lloyd @ 11/23/2008 9:21:48 AM
RE: Querying VFP database using Access 2007 Posted by M. Akram Bhatti @ 11/23/2008 10:22:29 AM
RE: Querying VFP database using Access 2007 Posted by Anders Altberg @ 11/23/2008 11:07:23 AM
RE: Querying VFP database using Access 2007 Posted by Jim Lloyd @ 11/23/2008 11:56:26 AM
RE: Querying VFP database using Access 2007 Posted by Anders Altberg @ 11/23/2008 1:03:52 PM
RE: Querying VFP database using Access 2007 Posted by Cetin Basoz @ 11/23/2008 2:09:36 PM
RE: Querying VFP database using Access 2007 Posted by Jim Lloyd @ 11/23/2008 6:50:00 PM
RE: Querying VFP database using Access 2007 Posted by Cetin Basoz @ 11/24/2008 12:50:53 AM