Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot open DBF with Excel
Message
From
24/11/1999 16:39:46
Ed Rauh
Trumbull, Connecticut, United States
 
 
To
24/11/1999 14:56:43
Robin Connelly
Retired
California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Cannot open DBF with Excel
Miscellaneous
Thread ID:
00294907
Message ID:
00295313
Views:
29
>So...
>
>VFP can build a file that Excel can read, but Excel can't read VFP's tables?

Excel 97 doesn't know about the changes to the DBF header in the VFP5/6 DBFs - so in order to make files that Excel 97 can understand, VFP has to create an older-style DBF header - the TYPE FOX2X clause of the COPY TO statement. VFP can work with both older and newer style DBFs, so it doesn't have any problems with the DBF files created by Excel 97.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform