Importing data by a user

I am wondering if someone can give me an elegant solution regarding
importing data. I am getting daily CVS files that I would like to import
into Access 2000. I already have the table setup with the fields already
name (i.e. policy number, insured, etc.) The problem is when I do an import
the fields are in a different name (i.e. a, b, c, d, etc.). I don't want to
rename the fields, data type over again. I just want to import and append
the table. Now here is the tricky part, I need it to be user friendly,
because the users are not familar with Access. Any advice or directions I
will appreciated. Thank you.

If you are quite sure the data will be valid (always the right number of
fields, order, consistent names, right data types, no duplicates, within any
validation rules, etc.), you could just attach the text file, and use an
Append query to map the fields to the fields of your main table.

In practice, you generally need to import into a table that has largely
untyped fields (text), run all the validation checks, identify the foreign
keys to associate the records with and so on. Once that's all right, use an
Append query to copy the data into the real table, and empty out the temp
table. And you probably need a log that creates a batch for each group, so
you can undo (delete all records in a batch), and also prevent the same file
from being imported twice.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alex Martinez" wrote in message
...
I am wondering if someone can give me an elegant solution regarding
importing data. I am getting daily CVS files that I would like to import
into Access 2000. I already have the table setup with the fields already
name (i.e. policy number, insured, etc.) The problem is when I do an
import the fields are in a different name (i.e. a, b, c, d, etc.). I don't
want to rename the fields, data type over again. I just want to import and
append the table. Now here is the tricky part, I need it to be user
friendly, because the users are not familar with Access. Any advice or
directions I will appreciated. Thank you.