long binary data

[Randy]

I have people in the field submiting excell spreadsheets
through a website which is tied into a SQL server which I
am linking to in my database in an OLE field. But when
they come into the DB it is as long binary data, which I
can not seem to do anything with. My users need to open
these from the DB. Any ideas?

[Trevor Best]

Re: long binary data

Randy wrote:[color=blue]
> I have people in the field submiting excell spreadsheets
> through a website which is tied into a SQL server which I
> am linking to in my database in an OLE field. But when
> they come into the DB it is as long binary data, which I
> can not seem to do anything with. My users need to open
> these from the DB. Any ideas?[/color]

Yuk, better to have that web page store the Excel file and tell the
database the unc path to it via a text ((n)varchar in SQL Server) field
then you can get to it unmolested.

--
This sig left intentionally blank