Importing a field correlated to other fields

[Guest]

So, there is going to be a convention in Japan in 2007. My database manages
the memberships of all the people who do not live in Japan or China.

We have decided to print our membership badges bilingually and this means
transliterating all of the names of the people in the database into katakana.
The plan is to dump the list of names into a spreadsheet and send that to
the translator, who will add a column to the spreadsheet with the
transliterated name in it.

Creating a new field in the table is easy enough, but how do I import the
data into the column so that each transliterated name is in the same record
as the original name?

Thanks muchly in advance,

Glenn

 

[John Nurick]

Export not only the fields containing people's names, but also any other
fields that form the primary key of the table. This may be a single
field (e.g. a "MemberID" field) or two or more fields.

Then when you need to import the transliterated names into the new
field, either link or import the Excel sheet, and then use an update
query that joins the Excel data and your existing table on the primary
key field(s) and updates the katakana name field.

You'll also need to ensure that you're using Access 2000 or later, and
that you and the translator both use a Unicode font that contains
western characters katakana, and any other characters the translator
needs.

 

[Guest]

Thanks, John!

That was perfect. I created a test spreadsheet with ID, First, Middle,
Last, Katakana with my name in it, imported it and updated the main table
with the update query and everything went fine.

Again, thanks for saving me a lot of hand input.

Best,

Glenn