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:25:38
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00702626
Message ID:
00702631
Views:
10
Hi Ajay,
>
>Is there any function or utility is available in VFP to convert ";" deleimited text file to MS Excel.

It depends if you now the structure of delimited file. If you know it try something like
...
CREATE CURSOR Cur_Temp () && your structure
APEND FROM your_delimited_file DELIMITED && look in help for right settings of WITH and DELIMITER
COPY TO your_exel_file XLS && OR XL5

USE
If you don't know to structure it is more tricky. You my open the file with Low level operations and scan the lines to catch the structure, and repeat as beyond.

An alternativ would be to use excel automation, but I have never done this.

HTH
Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform