Reading Values From An Image Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There's a field name UploadContent in a table call, say, Upload in a SQL Server table. The field UploadContent is of datatype image

The field is populated with an gif file version of an Excel Spreadsheet. The Excel spread sheet has columns of Account Number and Amount, with values in each cell of the columns

Does anybody know how to read these Account Number and Amount values from this field UploadContent using SQL Server 2000 and ADO.NET? I find it difficult at this point because an image field contains binary data

Thanks for info.
 
Hi Anonymous,

It is a known problem, but I lost the solution.

If I was you I would ask this in a Office developper newsgroup.

I thougtht me to remember that there are people in those newsroups, who know
the solution for this problem.

Cor
 
Hi,

As you only have a gif-image of the spreadsheet, I guess you need an
OCR-function (Optical Character Recognition) to convert the "image" back
into text. As far as I know this is not included in .NET, so you will have
to look for some external library (e.g. from document processing, scanning,
vision systems, ..).

Regards,
Jan

Anonymous said:
There's a field name UploadContent in a table call, say, Upload in a SQL
Click to expand...
Server table. The field UploadContent is of datatype image.
The field is populated with an gif file version of an Excel Spreadsheet.
Click to expand...
The Excel spread sheet has columns of Account Number and Amount, with values
in each cell of the columns.
Does anybody know how to read these Account Number and Amount values from
Click to expand...
this field UploadContent using SQL Server 2000 and ADO.NET? I find it
difficult at this point because an image field contains binary data.
 
Thanks a lot for the info, Cor and Jan

Here's another question. Say, the file is not saved in the field UploadContent as a gif file. Can it be saved in that field in other formats that it can be read as text? Eg., save the Spreadsheet in the UploadContent as a XLS file (ie., text format that has comma delimiters, etc.
 
Anonymous,

If you have the original .xls file you can store that one instead of the
..gif file. Both or nothing but binary data.

But are you sure you want to store it in a database. Why not just store a
reference to the excel-file in the database and save the excel-file(s) in a
normal directory ?

Regards,
Jan

Anonymous said:
Thanks a lot for the info, Cor and Jan.

Here's another question. Say, the file is not saved in the field
Click to expand...
UploadContent as a gif file. Can it be saved in that field in other formats
that it can be read as text? Eg., save the Spreadsheet in the UploadContent
as a XLS file (ie., text format that has comma delimiters, etc.)
 
Back
Top