how to convert a MsAccess database table which contains formated string values in the field (like ###99@<) to simple plain text format.
9 2701
Just create a query and format the field(s) as you like.
Next use the Export option when right-clicking the query to create a textfile when the SaveAs dialog opens chose .txt as filetype.
Nic;o)
NeoPa 32,556
Expert Mod 16PB
how to convert a MsAccess database table which contains formated string values in the field (like ###99@<) to simple plain text format.
This really depends on what you mean.
Do you simply want to change the format of the data as displayed in Access?
Is the data stored in this format or is it simply displayed that way using the Format property?
Has the data itself been preformatted and you want to update the data in your table?
This really depends on what you mean.
Do you simply want to change the format of the data as displayed in Access?
Is the data stored in this format or is it simply displayed that way using the Format property?
Has the data itself been preformatted and you want to update the data in your table?
the data was preformatted using some functions which i didn't know ,all i want is to see the data in normal text format.
NeoPa 32,556
Expert Mod 16PB
Well, I can't tell you how to do that until you answer my questions about how the data is currently.
I can't find that out without access to your database, so you'll have to do that for yourself.
If that's too complicated for you, let us know where you get stuck and we can help you. I don't intend to do everything for you though - you've got to put something in yourself.
Well, I can't tell you how to do that until you answer my questions about how the data is currently.
I can't find that out without access to your database, so you'll have to do that for yourself.
If that's too complicated for you, let us know where you get stuck and we can help you. I don't intend to do everything for you though - you've got to put something in yourself.
Respected sir,
as per ur advice on ur last reply ,i tried myself to change the text,
but all in vain.so once again i need ur help in this matter. first i explain the things. i have a database with 35 tables .content of all tables is in the text format except one table.that table contains some kind of text like currency or dollar format text.a sample of words in one column of the table is m?(>8!9m$#m!).like this all values in all coloumns on that table looks.pls give me a solution to convert this type of text into normal text format.i will be very thankful too you if you do that.i am a small girl & not so fluent in english.so if any kind of mistakes in my way of telling, pls forgive me.waiting 4 ur reply.
Respected sir,
as per ur advice on ur last reply ,i tried myself to change the text,
but all in vain.so once again i need ur help in this matter. first i explain the things. i have a database with 35 tables .content of all tables is in the text format except one table.that table contains some kind of text like currency or dollar format text.a sample of words in one column of the table is m?(>8!9m$#m!).like this all values in all coloumns on that table looks.pls give me a solution to convert this type of text into normal text format.i will be very thankful too you if you do that.i am a small girl & not so fluent in english.so if any kind of mistakes in my way of telling, pls forgive me.waiting 4 ur reply.
What are these functions you keep speaking of?
NeoPa 32,556
Expert Mod 16PB
Respected sir,
as per ur advice on ur last reply ,i tried myself to change the text,
but all in vain.so once again i need ur help in this matter. first i explain the things. i have a database with 35 tables .content of all tables is in the text format except one table.that table contains some kind of text like currency or dollar format text.a sample of words in one column of the table is m?(>8!9m$#m!).like this all values in all coloumns on that table looks.pls give me a solution to convert this type of text into normal text format.i will be very thankful too you if you do that.i am a small girl & not so fluent in english.so if any kind of mistakes in my way of telling, pls forgive me.waiting 4 ur reply.
I don't blame you for any mistakes in English. I simply don't understand what you're asking for. It doesn't matter if you're a little girl or a big man - if I can't understand then I can't answer.
You don't explain what needs to be converted to what in your post. Your example doesn't help me to understand what to change to what. Nor have you explained how your data is stored - which tables? which fields in the tables? etc.
Sir, it is a msaccess database table which contains two coloumns id & description with twenty rows.the field value of rows of id column contains 1,2,3.... and the field value of rows of description contains symbols like m>4!9#$ like that.New to msaccess i dont know how it was stored.Thats what i am unable to explain u correctly.It was a sample northwind database that was installed when i bought my system.I do self study learning of msaccess by doing step by step excersices.Now i am doing excersices of converting the values to another data types and suceeded through the formating option and save as option.This one i am unable to do it.Due to curiosity i am asking u this sir.
NeoPa 32,556
Expert Mod 16PB
OK, we seem to be getting closer. Please answer all the following questions. - Do you want to display the changed data in a query? OR update the data in the same table it's already in? OR write the updated data into a new table?
- What change do you want to do to the data?
- Is it currently stored as Text in your table?
Lastly, can you post the actual data if it's only 20 lines. It's hard to know what sort of data you're talking about with just a couple of strange examples.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: James Turner |
last post by:
I am trying to store formatted text (windows format) into a MySQL
database and then retrieve it. The field in the database is a
varchar. I cut and paste the test into a form field formatted, then...
|
by: Loi Tan Vo |
last post by:
Hi,
I have a text file that contains a date column. The text file will be
imported to database in SQL 2000 server. After to be imported, I want
to convert the date column to date type.
For...
|
by: rob.kellington at gmail |
last post by:
Does anyone have the logic to convert RTF formatted data in a text
column into plain ascii text that I can use in a varchar variable or
field?
We have an app that allows formatted comments/notes...
|
by: aevans1108 |
last post by:
expanding this message to microsoft.public.dotnet.xml
Greetings
Please direct me to the right group if this is an inappropriate place
to post this question. Thanks.
I want to format a...
|
by: whatluo |
last post by:
Hi, all
I'm now working on a program which will convert dec number to
hex and oct and bin respectively, I've checked the clc but with no
luck, so can anybody give me a hit how to make this done...
|
by: npoitras |
last post by:
Hi
I inherited a database that has a field containing the data I need stored in rtf format. I am hoping someone can help me find a stored procedure that I can use to pass the contents of the rtf...
|
by: phil.swenson |
last post by:
I'm using Prototype.js and would like to convert the contents of an
HTML table to JSON. Converting to an array first is fine too. Any
thoughts on this? I haven't seen anyone do anything this.......
|
by: NEWSGROUPS |
last post by:
I have data in a table in an Access 2000 database that needs to be exported
to a formatted text file. For instance, the first field is an account number
that is formatted in the table as text and...
|
by: Andy B |
last post by:
I have the object property StockContract.Dictionary which is a dictionary
collection of <string, stringkey/value pairs. I need to be able to
retreive the keys and their values and display them on a...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
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: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
| |