conversion number into text format

P

Pagoto

Working with a database of more than 1 million rows.
How can I convert a field from numeric into alfanumeric. I already try to
change the format but encounter always an error telling not enough memory.
Can this be done in programming language?

Urgent please.

Much obliged

Christophe
 
T

Tom Lake

Pagoto said:
Working with a database of more than 1 million rows.
How can I convert a field from numeric into alfanumeric. I already try to
change the format but encounter always an error telling not enough memory.
Can this be done in programming language?

Urgent please
Click to expand...

Have you tried changing the table design?

Tom Lake
 
J

John Spencer

One method
Add a new field to the table of the proper type (text) and size.
Use an update query to convert the value and populate the new field.

UPDATE YourTable
Set NewField = OldField & ""
WHERE OldField is Not Null

I don't have a table of sufficient size available to test this, but have you
tried just changing the field type in the table? I don't have any trouble
with my test table of 250,000 records and the conversion takes less than 15
seconds.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top