[Access] Conversion de champ texte en nombre
slyleglobetrotter
Posted messages
7
Status
Membre
-
YBouBou Posted messages 2 Status Membre -
YBouBou Posted messages 2 Status Membre -
Hello forum,
In an Access data table, I have a field where the data has been set to "text" type. The problem is that these are actually numeric data...
Is there a way to quickly convert the type of my field without losing information or modifying my database?
Thank you for your help.
Sylvain
In an Access data table, I have a field where the data has been set to "text" type. The problem is that these are actually numeric data...
Is there a way to quickly convert the type of my field without losing information or modifying my database?
Thank you for your help.
Sylvain
Configuration: Windows XP Firefox 2.0.0.1
8 réponses
Hello everyone,
My name is Guillaume and I am an adoption Data Manager...
I have been using Access for a short while.
I only work in design mode.
The problem:
At my workplace:
In a table, when I want to convert a data type from "Text" to "Numeric" (Double real, scientific, auto):
In my fields, 4.6e-005 becomes 4.60E-05; 36 becomes 3.60E+01.
Perfect!
When I get home:
When I try to reproduce the action, I get the following error message:
Microsoft Office Access has encountered errors while converting data.
The contents of the fields of 355 records have been cleared.
Do you still want to proceed?
Can you help me?
Thank you.
My name is Guillaume and I am an adoption Data Manager...
I have been using Access for a short while.
I only work in design mode.
The problem:
At my workplace:
In a table, when I want to convert a data type from "Text" to "Numeric" (Double real, scientific, auto):
In my fields, 4.6e-005 becomes 4.60E-05; 36 becomes 3.60E+01.
Perfect!
When I get home:
When I try to reproduce the action, I get the following error message:
Microsoft Office Access has encountered errors while converting data.
The contents of the fields of 355 records have been cleared.
Do you still want to proceed?
Can you help me?
Thank you.
Hello,
you open your table in "design" mode and change the column type...
If there's a problem, ACCESS will tell you (presence of letters or others).
If, however, you don't want to change anything, then you'll need to convert the data "on-the-fly," when using it (if you're performing calculations on it...)
--
See you later Blux
you open your table in "design" mode and change the column type...
If there's a problem, ACCESS will tell you (presence of letters or others).
If, however, you don't want to change anything, then you'll need to convert the data "on-the-fly," when using it (if you're performing calculations on it...)
--
See you later Blux
"You can count on idiots to do anything. It's even how you recognize them."
Hello,
I have a similar problem:
I am working on a database where the first 10 columns are text and the following 150 are numeric. The problem is that all the numbers in these latter columns that don't have any digits after the decimal point are recognized as text and have a ' at the beginning.
If I select all this data and go to Format>Number, it doesn’t change anything due to the little '.
What I really need to do is select a column>Data>Convert. However, I would have to repeat this operation about 16,000 times. In other words, it’s a nightmare.
Since this is a function I need to repeat, I thought perhaps a macro could do it for me. But I’m not good at VBA, and I’ve been struggling for a while, which is why I’m reaching out for help!
So here it is: Do you know of a little macro that would allow me to automate this manipulation?
Thank you a thousand times in advance!!!!!! :-)
Elendis.
I have a similar problem:
I am working on a database where the first 10 columns are text and the following 150 are numeric. The problem is that all the numbers in these latter columns that don't have any digits after the decimal point are recognized as text and have a ' at the beginning.
If I select all this data and go to Format>Number, it doesn’t change anything due to the little '.
What I really need to do is select a column>Data>Convert. However, I would have to repeat this operation about 16,000 times. In other words, it’s a nightmare.
Since this is a function I need to repeat, I thought perhaps a macro could do it for me. But I’m not good at VBA, and I’ve been struggling for a while, which is why I’m reaching out for help!
So here it is: Do you know of a little macro that would allow me to automate this manipulation?
Thank you a thousand times in advance!!!!!! :-)
Elendis.
Hello,
I didn't mean to be unpleasant. I simply pointed out that the topic was about ACCESS, while you asked a question about EXCEL (without mentioning it, by the way; it's left to us to play guessing games!). It is clearly stated on this forum that we should avoid mixing genres so that everyone can find an answer to a previously addressed issue without having to go through all the messages.
The initial message is about ACCESS, and I suggested that you create a new message about EXCEL.
As for finding an answer elsewhere, in a more "welcoming" forum (sic), feel free to go there...
--
Cheers, Blux
I didn't mean to be unpleasant. I simply pointed out that the topic was about ACCESS, while you asked a question about EXCEL (without mentioning it, by the way; it's left to us to play guessing games!). It is clearly stated on this forum that we should avoid mixing genres so that everyone can find an answer to a previously addressed issue without having to go through all the messages.
The initial message is about ACCESS, and I suggested that you create a new message about EXCEL.
As for finding an answer elsewhere, in a more "welcoming" forum (sic), feel free to go there...
--
Cheers, Blux
"Fools dare everything. That's how you recognize them."
Hello everyone
here's my problem, I have a table where the date field is numeric because I have presumed dates and I want to create a query that gives me the list of everyone who was born, for example, in 1980 (i.e., by year). So I'm struggling to solve the problem, i.e., how to do it.
I have 20 out of 1000 presumed employees.
it's extremely urgent
thank you in advance
nadjla
here's my problem, I have a table where the date field is numeric because I have presumed dates and I want to create a query that gives me the list of everyone who was born, for example, in 1980 (i.e., by year). So I'm struggling to solve the problem, i.e., how to do it.
I have 20 out of 1000 presumed employees.
it's extremely urgent
thank you in advance
nadjla
Hello,
I would like to know how I could, when entering text data in Access, immediately convert it into a numeric value in the table.
For example, if I enter F, Access displays 1, or if I enter H, Access displays 2.
Thank you and long live Audiard!
I would like to know how I could, when entering text data in Access, immediately convert it into a numeric value in the table.
For example, if I enter F, Access displays 1, or if I enter H, Access displays 2.
Thank you and long live Audiard!
You can find them to modify, I suggest a query that displays the field, its numeric status, its ability to be converted to a number, and whether it contains spaces (since space is part of a number):This can give results like this:Then, you just have to modify the non-numeric fields...
--
See you Blux