Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From (spreadsheet): column names?
Message
 
 
To
11/07/2006 08:01:27
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01134756
Message ID:
01135283
Views:
17
>Hi Cetin & Naomi,
>
> Thanks for the suggestions, but I was hoping for some way to query the FoxPro cursor for this information rather than asking Excel because the client might be using Lotus spreadsheets. I never know in advance what type of spreadsheet they will use (although it must be one of the types supported by VFP EXPORT TO and APPEND FROM).
>
> Is there any way to get the column names from the FoxPro cursor created from APPEND FROM?
>
> Thanks, Chaim

If you meant import, you may then examine the table using afields function to get fields names into array. If you're using APPEND FROM then the table must exist in advance.

I have another function of converting Excel into DBF and producing structure table. Unfortunately, sometimes some fields map to wrong types/dimensions. Anyway, let me know if you want this function.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform