Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel transfer
Message
From
28/05/2002 08:17:52
Denis Filer
University of Oxford
United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Excel transfer
Miscellaneous
Thread ID:
00661940
Message ID:
00661940
Views:
52
Importing data from Excel, I have some problems:

The prg attempts to sensibly rename the A B C etc Excel fields using a record selected by the user in the file i.e. with the field names. Follwing this, we often get:

1. Truncation of character fields
2. Strange behaviour of data in the DBF e.g. if you trim the data to remove leading spaces, it truncates to one character; inclusion of certain characters (Excel print features perhaps) that cause the data to disappear when selected. I am using the IMPORT FROM command type XL8.
Any comments appreciated ... Denis
Next
Reply
Map
View

Click here to load this message in the networking platform