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,

 

[Pat Hartman]

Add a temporary column to the table. Create an update query that takes the text column and puts its value in the new numeric column. Once you're sure that the new field has been properly populated, delete the original text column and rename the numeric column.

 

[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.