Transforming data

[keith2511]

Grateful for suggestions on how best to tackle two issues when importing data from Excel.

I want to change the contents of a field containing location names. Up to now, I've created a lookup table with name-in and name-out fields. Once the data is imported, I then run an append query to another table which uses a relationship to the lookup table to add the name-out value to each record. Can this type of transformation be accomplished in the table that initially receives the imported data without having to run the append part of the process?

The data includes invoice dates and I want to be able to report on data by month and year. What is the best way change dates into just month and year?

Thanks

[ranman256]

you dont need to change the date to month/year, just view it via :format([dateFld],"yyyymm")

you can run the lookup via an append query at import,
or
you can run an update query anytime to modify that field

[keith2511]

OK thanks for replying.