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.

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

Thank you- that helped

No problemo, glad it helped.

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!!!

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

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.