>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.)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only