Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting from excel or text files into memo field
Message
From
27/04/2001 08:36:09
 
 
To
27/04/2001 08:32:08
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00500539
Message ID:
00500575
Views:
37
One last (cheating) solution...

If you have control over what's in the Excel file - you could put a start of line and end of line marker in each cell you want to extract then grab the file with a filetoStr (or fOpen/fRead) and extract each line of text.

Or.. you could delve into the structure of an Excel file... but it's probably not worth it!

Will

>I'm all out of ideas.. maybe someone else can jump in with a suggestion?
>
>
>
>>This case probalby in not acceptable, because the application will run widely in a country and I'm not shure that excel automation will run on any machine.
>>
>>Vytas
>>
>>>In that case you may have to extract the data using Excel automation
>>>then insert into the memo field each value from Excel
>>>
>>>Will
>>>
>>>>Import command creates a dbf with a field of type charecter(254).
>>>>If in excel file clell content is longer, vfp cuts it.
>>>>I need full information.
>>>>
>>>>Vytas
Will Jones
Previous
Reply
Map
View

Click here to load this message in the networking platform