Re: Problems with linking to Foxpro tables

From: Henrik (Henrik_at_discussions.microsoft.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 01:47:01 -0700

Hi Cindy,

thank you for replying.

I already tried using the Visual Foxpro ODBC driver. Then I got the issue
with national characters I mentioned. National characters entered and
displayed correctly in the DOS-based Foxpro application somehow get
translated to other national characters in Access.

Now, this is most probably some NLS/code page issue, but as far as I can see
the driver does not allow me to select what code page to use. I can select
the collation order, but that doesn't seem help at all.

The dbase ISAM driver as well as the old Foxpro ISAM driver handles any
national characters I throw at them completely flawlessly.

I got a couple of ideas for a solution, but don't know how to implement them.

One would be to install the old Foxpro ISAM driver in a XP/Office 2003
environment, íf it's possible at all. I don't know how to do this or if it's
possible at all.

The other would be if there is a way to tell the ODBC driver what code page
the Foxpro application uses, so it can handle the character translation
correctly. I don't know how to do this or if it is possible.

Best regards,
Henrik

"Cindy Winegarden" wrote:

> Hi Henrik,
>
> Use the FoxPro and Visual FoxPro ODBC driver, downloadable from
> http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy.winegarden@mvps.org www.cindywinegarden.com
>
>
> "Henrik" <Henrik@discussions.microsoft.com> wrote in message
> news:00E9042A-FAE7-4EC3-BF80-9763766541ED@microsoft.com...
> > Reading the tables as dBase III/IV ISAM files works fine, national
> > characters and all, except for the two tables that contain Memo fields.
>
>

Relevant Pages

  • Re: Word Mail Merge with Foxpro data
    ... As long as you have the updated FoxPro ODBC driver (I think you will see ... at open" to ensure that the extra dialog to "confirm the data source" is ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Foxpro Data Base
    ... if the file->get external data import using dBaseIII does not work, ... how could FoxPro read this stuff???). ... You should work on using the odbc driver. ...
    (microsoft.public.access.externaldata)
  • Re: Meta-Data or Actual Data
    ... Which I assume pulls from the metadata of the table. ... Is there an equivilant for the ODBC driver FROM Table, which I assume reads every record in the table) ... I meant that I'm using the VFP 6 ODBC driver to get those record counts from FoxPro. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: FOXPRO DRIVER
    ... This is the Foxpro 5.0 ODBC driver which is listed as backward compatible ... > getting License_metering error messages and the only fix I ...
    (microsoft.public.sms.setup)
  • Re: Access import off Fox Pro Tables
    ... I am having an issue installing the visual fox pro driver. ... and try to install from the link you provided, I am getting the error "The ... How can I get this VFP odbc driver? ... > Start with the latest ODBC driver for FoxPro and Visual FoxPro, ...
    (microsoft.public.access.externaldata)
Loading