By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,854 Members | 869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,854 IT Pros & Developers. It's quick & easy.

2003 and Long Binary Data

P: n/a
I have heard that access 2003 has functions for dealing with Long
Binary Data. Does anyone know if this is true?
Background:
I am using 2000 with a table linked to a SQL server. One of the fields
is of type OLE Object. This table is populated from a website where
excell spreadsheets are uploaded. But in the linked Access table
instead of saying Excell spreadsheet in that field it says Long Binary
Data, which can not be opened. My users on this end to open or export
that file preferably as .xls but .txt, or .csv format would work.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ra**********@hughessupply.com (Randy) wrote in message news:<86**************************@posting.google. com>...
I have heard that access 2003 has functions for dealing with Long
Binary Data. Does anyone know if this is true?
Background:
I am using 2000 with a table linked to a SQL server. One of the fields
is of type OLE Object. This table is populated from a website where
excell spreadsheets are uploaded. But in the linked Access table
instead of saying Excell spreadsheet in that field it says Long Binary
Data, which can not be opened. My users on this end to open or export
that file preferably as .xls but .txt, or .csv format would work.

randy,
I'm not an expert on this, but I think the data at the SQL-server-side
should be of the image-datatype to be accessed from Access as
OLE-object. i found some info on
(http://msdn.microsoft.com/library/de...designeff.asp).

Marc
Nov 13 '05 #2

P: n/a
Have you tried saving the contents of the field to a disk file and then
trying to load the file in Excel. I say this because the original Excel
file may have been inserted as binary data.

Create a form with an OLE Frame control bound to the field in question.

Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click

Dim a() As Byte
Dim lTemp As Long
Dim sl As String

lTemp = LenB(Me.olePicture.Value)
ReDim a(0 To lTemp) ' should be -1

' Copy the contents of the OLE field to our byte array
a = Me.olePicture.Value

sl = "OLEfieldTestExcel" & ".xls"
Open sl For Binary Access Write As #1
Put #1, , a
Close #1

Exit_cmdSave_Click:
Exit Sub

Err_cmdSave_Click:
MsgBox Err.Description
Resume Exit_cmdSave_Click

End Sub

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Randy" <ra**********@hughessupply.com> wrote in message
news:86**************************@posting.google.c om...
I have heard that access 2003 has functions for dealing with Long
Binary Data. Does anyone know if this is true?
Background:
I am using 2000 with a table linked to a SQL server. One of the fields
is of type OLE Object. This table is populated from a website where
excell spreadsheets are uploaded. But in the linked Access table
instead of saying Excell spreadsheet in that field it says Long Binary
Data, which can not be opened. My users on this end to open or export
that file preferably as .xls but .txt, or .csv format would work.


Nov 13 '05 #3

P: n/a
Thank You very much!
It works perfect!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.