asked on

Copy data in a text field to a numeric field

Hi. I created a table with a text field by mistake. Only numeric data has been entered in this field but formatted for text. Worked great until I need to link it to a table with a numeric key. Easy fix is to create a numeric field and copy text data into the new field in each record in numeric format since there are now thousands of records.

Is there some way to convert text data to numeric and import into that new field? Any suggestions would be great as I don't want to manually tweak each record.

thanks

SOLUTION

danishani

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

Mike Eghtebas

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

GRayL

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

valmatic

ASKER

Thanks all for the help.
Dan, I tried changing the field type before and I was not able. Tried it again and it worked. Very strange. Not the way I wanted to go since it left to much backend work on my queries/forms though.

Otherwise I took pieces of each post and made it work the way I needed it too so I'm splitting the points. Hope noone minds.