Importing data by a user

[Alex Martinez]

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.

 

[Allen Browne]

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.