macro for write in field on one table

[Helder De Pinho]

Hello

[I speak french, sorry for my english ...]

I have a table on my DB and I want to modify all the datas of one field.
I need the write some text before that was write on the field


en français :

bonjour,

je cherche à modifier tous les enregistrements d'un champ en concaténant
un autre bout de texte à ce qui est dans le champ.

Merci et meilleures salutations !

 

[Steve Schapel]

Helder,

You would use an Update Query for this. Update [YourField] to...
"Your new text " & [YourField]
Hope you will understand what I mean.

You can just run the Update Query to modify your data. If you need to
automate the process with a macro, you can use the OpenQuery action in
the macro.