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:
01510464
Views:
65
>Hi,
>
>Is it possible to save/insert/embed an excel spreadsheet into a field of a VFP or SQL Server database? What kind of field would it have to be? TIA.

Yes, it's possible. You can use blob / varbinary(max) field in SQL Server. If you're using SQL Server 2008 you can investigate FileStream option also.
Finally, the simplest solution is to keep the Excel on the disk and just store the fullpath and name to it.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform