Updating from a CSV - Stupid Question

[SteveC24]

Hello,

I know this is a really stupid question, and is almost definately a FANTASTICALLY easy to solve problem, but I can't figure it out!

I have a list of students, with all of their details (dob, names, registration groups etc.). This needs to be kept updated - and I receive regular updates in the form of CSV files, with all the information that table contains in it.

Several other tables and queries depend on the data in this table. Each student is identified with a unique StudentID.

I need to give the db this new csv (that may or may not have any changes in it), and have the db update my table with deleted students, changed names and new students.

How do I do this?!?
Thank you in advance!

 

[M8KWR]

you could do this one of 2 ways.

Instead of importing the csv file each time it change, you could link the file to access. Then just overwrite the file on your network with the most up-to-date version, then anybody can do this.

But the second version I would do is to link to a csv file, the new version, but you have the old version in a table within the database.

You have a query to ammend the records from the new version to the old version etc.

I would go with the first one myself, but depends on the amount of data you are talking about, because this will run slower then if the data was actually in the access file.

Hope this all makes sense.

any issue let me know