Change field type

[Jeff]

I have a table with 298,000+ records with mostly text fields. One of the
fields, named SALES, is a text field. It did look like $5,000,000 but I
removed the symbols and now it looks like 5000000 as an example. Everytime I
go to datasheet or design view to change it from a text to number field it
gives me an error message that I do not have enough disk space or memory. I
have 2G of ram and over 50G of free disk space.

 

[James A. Fortune]

I have a table with 298,000+ records with mostly text fields. One of the
fields, named SALES, is a text field. It did look like $5,000,000 but I
removed the symbols and now it looks like 5000000 as an example. Everytime I
go to datasheet or design view to change it from a text to number field it
gives me an error message that I do not have enough disk space or memory. I
have 2G of ram and over 50G of free disk space.

See if the following works:

Copy and paste on the table name, but copy only the structure of the
table using a new table name. Change the field type to currency. Run
an append query that selects all the records of the first table and
appends them to the second table. Check to make sure everything is
correct. If so, delete the first table and rename the second one.

James A. Fortune
(e-mail address removed)

 

[John W. Vinson]

I have a table with 298,000+ records with mostly text fields. One of the
fields, named SALES, is a text field. It did look like $5,000,000 but I
removed the symbols and now it looks like 5000000 as an example. Everytime I
go to datasheet or design view to change it from a text to number field it
gives me an error message that I do not have enough disk space or memory. I
have 2G of ram and over 50G of free disk space.

Answered in your other thread. Create a new empty table with all the same
fields, change this field to Number (or Currency, probably better!) and run an
Append query to migrate the data.

 

[fredg]

I have a table with 298,000+ records with mostly text fields. One of the
fields, named SALES, is a text field. It did look like $5,000,000 but I
removed the symbols and now it looks like 5000000 as an example. Everytime I
go to datasheet or design view to change it from a text to number field it
gives me an error message that I do not have enough disk space or memory. I
have 2G of ram and over 50G of free disk space.

Asked less than 2 hours ago and you have received several replies.
If you are unhappy with the replies, at least keep the follow-up
question in the same thread instead of starting a new thread.