Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Conversion of text file into MS-Excel
Message
From
20/09/2002 05:34:03
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00702626
Message ID:
00702635
Views:
11
Ajay,

You could read the data from the text file into a VFP cursor and then copy the data to Excel:
CREATE CURSOR TempCursor (...)
APPEND FROM TextFile DELIMITED WITH CHARACTER ";"
Copy2Xls()
See FAQ #8026 for the Copy2Xls() function which works around the 16K record limitation of the COPY TO XL5 command.

HTH
>Hi All,
>
>Is there any function or utility is available in VFP to convert ";" deleimited text file to MS Excel.
>
>TIA
>Ajay
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform