conversion number into text format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
..
 
Back
Top