Analyse the XLS, the created txt file, something could not be translated. You need to figure out what.
Agnes
>thank you for reply
>i try as below ,same error Microsoft Excel file format is invalid
>Local lcExcel
>lcExcel = GetFile("xls")
>IMPORT FROM (lcExcel) TYPE XL5
>
>>Try
Import from yourexcelfile xl5
>>
>>Agnes
>>
>>>thank you for reply,
>>>
>>>i try it i get error message
>>>Microsoft Excel file format is invalid , when i use vfp wizard i convert this excel sheet to txt file no proplem,
>>>
>>>when i use wizard to convert excel to dbf i get same error
>>>
>>>i get error for one column have names, if i remove this column it works ,
>>>
>>>but i need to do it via vfp code
>>>
>>>thanks
>>>
>>>>You can do this in a million different ways, one of the the easiest is this:
>>>>Import from yourexcelfile xls
>>>>_vfp.DataToClip(,,1)
>>>>StrToFile(_cliptext,'yourtextfile.txt')
>>>>If this is not how you want the txt file to look like, you must provide more info. Since a txt file is just a text file, there is no standard for this file.
>>>>
>>>>
>>>>>hi all,
>>>>>
>>>>>i need help to convert excel sheet to txt via vfp code
>>>>>
>>>>>thanks
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.
OffThere is no place like [::1]