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 13309
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
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?
@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 `
@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..
@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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |