Reading Data From MS Access data file

[bobmpalmer]

Is there a way to directly read data from an MS Access datafile in VFP?


Bob Palmer

http://www.resisystems.co.uk

The most common solution is H2O!

 

[Mike Lewis]

Bob,

No, not directly. But you can do it via ODBC (quite easy) or Automation (not quite so easy, but do-able).

You can also export Access to FoxPro from within Access.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[JRB-Bldr]

As Mike suggests above, you could set up a permanent Remote View (which uses ODBC and an SQL Query) into your Access data table.

NOTE: To change data in the Access table you will want to make modifications to the CURSOR Properties in order to enable modifications. And you might want to study the differences between the various types of Buffering to decide which works best for you.

Then when you need the data you USE the Remote View and the data is there for you in a 'pseudo' VFP table.

Good Luck,
JRB-Bldr

 

[baltman]

Import DB from MS Access faq1251-5002

Brian