Post reply

Display varbianry(max) in Excel or Word

  • May 20, 2008 at 9:14 am

    #96304

    I managed to store excel files into varbinary(max). Now I need to get it out and fire up excel to display the data. I retrived the data as FileStream already. Anyone can help me to open it in Excel?

    Thanks!!!!!

  • May 21, 2008 at 11:01 am

    #818745

    I am not sure why you would have used VARBINARY(MAX) rather than a blob field, but the answer is to stream the TextStream to a file and launch Excel giving it the file path. You can use the current user's temp directory - make sure you generate unique file names or use a GUID.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply