Change field values on append/import

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

RitchieJHicks

Hi,

I have a table2 that I append on a daily basis to a main table1.

However, within one of the fields of table2 (supplied by a client) they have
for fields:

UKR1
UKR2
UKR3
UKR4

I would like the import query to change the values to the follow as I run
the append query:

UKR1 to become Runner
UKR2 to become Runners and relay
UKR3 to become become UK Runners, Relay and Home
UKR4 to become UK Runners, Relay and European

Is it possible to have a query make the changes as I import the data? Or do
the changes have to be made in the table prior to importing the data?

Many thanks.
 
Hi Ritchie,

Try linking to the table and then using an append query that makes the
value conversions. If the names of the incoming files change daily, you will
need to set up a process to relink them each time before running the append
query.

Clifford Bass
 
You can use the Switch function in your append query. You can find details
on the Switch function in VBA Help.
 
Back
Top