datatypes

[cvaccess]

I need to convert a column that was originally set as a text datatype for numbers. Well now that I need the data for the queries. I need to use it as a number datatype. Because the table contains 417,000 records I can't convert it by changing the datatype due to memory space. Also, I have tried copy and paste and that only takes 45,000 records. Any easier method of doing this?

Thanks,

 

[cvaccess]

That didn't work because of the volume. I ended up creating an append query to a new table with the changes and then renaming it. Thanks for your input.