Update Query to Translate Text

[NoelMG]

We are importing data from a spreadsheet, which is generated by a website from registration forms that people fill in.

I have to get the data into the database, and in the right format etc and have got 90% of the way there with the rest of it!

Trouble is, a lot of the options are in different languages (French, Portuguese, Spanish, German, Italian). The phrases are all fixed (from a combo box) for instance we have "Group 1", "Gruppo 1", "Groupe 1" etc for one of the questions.

I've tried an Iif statement to translate, but there are that many different options it doesn't like it! Is there a way I can have the translation text all in a table and do an update query based on this? (for instance, record 1 would have each translation for "Group 1" and so on.

Hope this makes sense!

Cheers,
Noel.

 

[mordja]

Noel,

Yes you could use a table filled with the update codes. First import all your data into your desired table. Now create a new table with two fields, oldvalue, newvalue. The old value contains the untranslated value and new value contains the translated value.

Create an update query and add the table containing all your data and your update table. Join the value you want to translate in your main table with the oldvalue in the update table. Select the field you want to update from your main data table and in the update to section enter [Tables]![yourUpdateTableName]![newvalue], changing the names as appropriate.

Run and your done.

Mordja

 

[NoelMG]

Sounds good - I'll have a go and let you know how I get on!

Thanks,
Noel.