Importing and append data

[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.

 

[Nikos Yannacopoulos]

Alex,

The easiest way - i.e. no code - is to link the .csv file (File > Get
External Data > Link), then make an append query and map fields as
required. Then all your users would have to do is save each new .csv
file in the particular folder with the same name every time (so the link
doesn't break), and run the append query.

HTH,
Nikos