Upload Excel file to a BLOB column. - Need Solution.

[Guest]

I having a problem where in I have to upload the excel document into BLOB db
column of a table. I tried and I was able to upload the excel document. when
the size of the excel document goes more than 32kb it fails and throws a
conversion error. other wise it is working as desired.

Following is the code I tried.

1) first i upload the excel file to the server.
2) The using byte stream I make the excel file to of file type
3) Then Insert the filetype to the BLOB column.

Please give me a very good solution.

 

[Guest]

The below problem is from ASP.net page and in VB.NET.
Framework is 1.1

 

[Cor Ligthert [MVP]]

AnBu,

Because you succeed in files from below 32Kb, I think showing you a
memorystream solution has no sense because you are using that most probably
already.

I don't know if you users should use it direct from your database. Otherwise
is in my idea Zipping it first forever a good solution. In Net 2.0 is
zipping integrated for 1.x are more than enough Zip solutions on Internet.

http://www.sharpdevelop.net/OpenSource/SharpZipLib/Default.aspx

http://www.gzip.org/zlib/

Cor

 

[Guest]

Hi Cor,

Thanks for your solution. Actually we tried and we have solved it. Now it is
uploading more than 32kb where we have to make chnages for our framework.

We will try your solution.

Regards
Anbu.

 

[avdhut]

I need to create Excel file from BLOB field from vb.net.

can you please help me out?

thanks.
avdhut

 

[Paul Clement]

On Wed, 12 Apr 2006 07:01:14 -0700, avdhut wrote:

¤ I need to create Excel file from BLOB field from vb.net.
¤
¤ can you please help me out?

What kind of database are you working with?


Paul
~~~~
Microsoft MVP (Visual Basic)