>It's not the old FoxPro Driver that concerns Bret. In Access you can create a "Link Table" that links directly to any one of the following file formats selectable in a dropdown list.
>Access tables, dBase III, dBase IV, dBase V, MS Excel, Paradox, Text Docuements, and others. FoxPro used to be on the list, but is was removed in Access 2000, helping to fuel the ol' Microsoft is dropping support for... well, you know.
Exactly. Furthermore, "Microsoft FoxPro 3.0 (*.dbc)" was an available option in Access 97 for import (not for linking tables). I see no good reason to remove these existing convenient functions.
Access 2002 did not put it back.
On the other hand, Access interoperability isn't always what it should be even with respect to the rest of MS Office. I discovered this KB article while looking at other ones that explain that most Access code and menu functions that export to Excel are creating an Excel 95 file, which Access 97 can't import. Even in Access 2002 that is still the case. (The DoCmd.TransferSpreadsheet method lets you choose the version number, in case anyone was wondering.)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement