Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Embed excel into VFP or SQL Server field?
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01510463
Message ID:
01510475
Views:
41
>>>>Thank you.
>>>>
>>>>I am testing this in VFP. How do I REPLACE a blob field with a spreadsheet? I tried
>>>>REPLACE MyBlogFld with SampleExcel.xls in MYTABLE but it does not work. What am I missing?
>>>>
>>>>>Blob in VFP, varchar(MAX)/Image in SQL Server.
>>>>>>
>>>
>>>Have you tried casting it to blob first?
>>
>>No. I didn't realize that I have to do it. I will look into help on how to do it. Thank you.
>
>Sorry, I wanted to update my quick response. You need to use FILETOSTR function first.

Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform