Removing a hyphen from a field

[Payal Patel]

Hi,
I am importing a file into an access table that have hyphens in the number. How do I remove the hyphens once the numbers are in the Access table?
Thanks,
P.

 

[pbaldy]

You can use the Replace() function either during the import or with an UPDATE query.

 

[Payal Patel]

Thank you- that helped

 

[pbaldy]

No problemo, glad it helped.

 

[JGG]

I need to remove a hyphen from a string, how would I write that in an Append Query? Replace([FieldName],"-"," ") is what I used and it didn't work, please advise!!!

 

[boblarson]

What do you currently have for the SQL for your Append Query? And which field are you wanting to do this with?

 

[JGG]

INSERT INTO [Formatted Host Meter] ( [Host Meter], [Formatted Host Meter] )
SELECT [Copy of ASN as of 08312010].Host_Meter, Replace([Host_Meter],"-","") AS Expr1
FROM [Copy of ASN as of 08312010];

***I'm trying to append it to a different table, and it's not doing it, I keep getting this message:
"The action or event has been blocked by disable mode"
It will remove the hyphen with what I wrote, but it won't put it where I asked it to go (the appended table)...please advise.