Hello,
I have a microsoft access file with fields that have "long binary data". I would like keep the same file, but change the "long binary data" into regular text. There are a large number of fields, so it needs to automated. I'm not a programmer, but a network engineer. Is there any way to do this without programming? Thank you, Ken
9  13335 
Hi Ken.
Before you can do anything to convert your data you must have a clear understanding of its structure. What you mean when you say 'long binary data' is unclear; long as in a 256-bit sequence, say? Or a 1024-bit data packet? Or Long as in Long Integer? If you simply want to convert long integer fields in a table to text you could take a copy of the table then change the field type from long to text. Job done. Or, you could use a query to convert the data type without changing the table at all, using the CStr function for example to convert to string format.
Otherwise, you will need to have a clear understanding of what the actual structure of your binary data is before you begin.
Even if you do have a clear understanding of the data, trying to represent binary data in ASCII text format is not generally at all successful. An 8-bit byte can take any value between 0 and 255, but ASCII's viewable character range is from 32 to 126 (excluding the extended ASCII codes from 128 to 254 which generate block lines and other special characters).
As ASCII was originally a 7-bit code its values stopped at 127. Later developments have extended that range, and the much-later Unicode representations of text have done away with ASCII restrictions, but as you are simply wishing to convert binary to text there is little point in considering these at present.
Even within ASCII's original range many valid ASCII values cannot be represented as viewable text (the control characters such as CR and LF, for instance).
It is possible of course to convert one format of data to another, but whether you will see anything meaningful by doing so is another matter.
I can't be more specific without knowing the structure of the binary data to which you refer.
Welcome to Bytes!
-Stewart
ADezii 8,834
Recognized Expert Expert
Access typically displays the text "Long Binary Data" in a field when it contains a BLOB (Binary Large Object). A BLOB can be any type of binary data, and is most commonly a copy of a file, such as a JPEG photo or other Graphic Image. The BLOB field contains a Byte-for-Byte copy of the file, so it can easily be extracted back to the File System resulting in an identical copy of the original file.
Are you speaking about converting the Long Binary Data Type Fields back to their original Files? If this is the case, do you know the Extension and/or FileNames associated with each Binary Field?
I am having the same problem.
@ADezii, I do not know what type of file of the original file attached to the Long Binary Data. Is there a way to identify this?
ADezii 8,834
Recognized Expert Expert @xtep2010
There must be some kind of Unique Identifier in the File's Header, but I am not sure as to where in the File (Offset) it may be. I'll look into this a little more when I have the chance.
@ADezii
@ADezii, I tried extracting it to .txt file and the content is
+ : I Z `
ADezii 8,834
Recognized Expert Expert @xtep2010
If it is in a Long Binary Data Format, chances are that the majority of Characters would be unreadable. What I can do is to Output the contents of each Long Binary Data Field to a Unique File Name with the generic Extension of *.dat (<Primary Key>.dat). You can then try to Open each File with various Apps in order to determine what kind of Extension should be associated with it, namely: *.jpg, *.bmp, *.txt, *.doc, etc. I won't attempt this unless you are actually interested.
@ADezii
I have tried it already.. it seems the data that was saved in the ms access database is compressed or encrypted..
ADezii 8,834
Recognized Expert Expert @xtep2010
Gotcha, thanks for saving me some trouble (LOL).
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Karen Grube |
last post by:
Hi!
Each week, we receive a two-page PDF file from UPS along with a separate
flat file (a CSV) The PDF file contains the overview of our weekly invoice
and the CSV contains the details of each shipment.
I download the file from UPS and then use DTS to import the data into
SQL. At that point, I have a Crystal report that prints what looks like a
regular UPS invoice. The only problem is that I wind up with having to print
two...
|
by: MLH |
last post by:
Precise determinations are not the objective.
I would lke a single button click approach to
creating a report/table/dynaset - whatever -
to display each table name and an approx-
imation of the number of bytes of storage
spaced occupied by the data in each table.
I don't remember seeing any discussion on
this topic over the years since Access 2.0
and up through the more recent releases.
|
by: Jerry |
last post by:
I have an off-the-shelf app that uses an Access database as its
backend. One of the tables contains a field with an "OLE Object"
datatype. I'm writing some reports against this database, and I
believe this field contains data I need. When I view the table in
datasheet view, all I can see in this field is the string "Long
binary data".
So, I've got the problem of needing to extract data from this
field, but I don't know what format...
|
by: Trip |
last post by:
Hello all,
Is there anyway to store an array to MS Access 2002 without parsing the
entire array row-by-row. For example, Oracle allows you to store BLOBs
(binary large objects). I would like to be able to say in VB/VBA
With rstName
.AddNew
!fieldName = ArrayName
.Update
|
by: nigel.thomson |
last post by:
Hello All
Is there an easy way to do this?
I have a database that contains records witha image as one of the
fields, what I want to do is export the images to a seperate folder, in
whatever foremat is suitable (gif, jpeg etc)
But i can't work out how to do this
This is all the information i have
| | |
by: alexandre.brisebois |
last post by:
Hi, I am using access 2003, I would like to know if there is an option
to reorganize the tables in a maner that is readable, as we can do in
sql sever 2000 or 2005.
I have been given a database to look a and I am loosing tremendious
amounts of time trying to organize it so that I could view it.
Regards,
Alexandre Brisebois
|
by: kev |
last post by:
Hi folks,
I have created a database to store information on equipments. During
the first level of registration, there is a form that i need the user
to fill up details on the equipment testing. i have done this one.Now
what i need is to enable the users to upload files and save it into the
corresponding table.
Example: 3. A laser inventory form has been completed for each 3b or
4 laser and submitted to the Laser Safety Officer...
|
by: bhodgins |
last post by:
Hi,
I am new on here, and had a newbie question that I am stumped with.
I am not new to access, but am new to VB.
I am trying to export BLOBs from a field called photo to external jpeg files. I have tried the MS kb 210486 and successfully got the import/export to work with a sample table, but only the first record. I do not wish to impost binary data to the database, it's already there. I simply wish to pick up the binary BLOB from the photo...
|
by: efrenba |
last post by:
Hi,
I came from delphi world and now I'm doing my first steps in C++. I'm
using C++builder because its ide is like delphi although I'm trying to
avoid the vcl.
I need to insert new features to an old program that I wrote in delphi
and it's a good opportunity to start with c++.
|
by: stuart |
last post by:
We have a forms application that captures comments digitally entered
by an inspector and saved as an image in Sql Server. The manager of
this inspector wants to be able to transfer the data in Sql Server to
Access 2003 table. However, when I try to export the data into an
Access table and into an OLE field, the field displays the information
as "long binary data".
Is there a way to transfer the data so the field in the Access table...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
| | |
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
