Have an issues with converting a data type.

Currently i have two columns that have entries such as 73.125 in every cell. There are 79,900 entries. Currently the column is a text data type and I need to convert it to a number format. However, whenever I try to do this the decimal points get cut off. It is crucial that I keep the decimal points. Is there anyway to do this within access, or through a processing page in ASP?

- Conrad

Try this:

1) Export your table into a TXT file.
2) Re-import your TXT file and use the following parameters:
delimited width
text qualifier: "
data type: double

It takes long to convert 79,900 entries but it works.

peter