Need a bit of help getting my head around this.
Its a fail for uploading new users and deleating old users. this needs to be a CSV file
What would be the best to do this excell or access
What i see happening is getting a csv file, form our database stripping out all the unwanted feilds then uploading the users with that file (call this current users).
then when i get the next weeks file from the database i ll strip it to get all the feilds I want(call this for the moment new information).
Will this work (new information - current users) = new file with just new users on.
then (current users - new information) = new file with users that need deleting?
If this will work whats the best way of doing the compairing the 2 files.
Cheers
Its a fail for uploading new users and deleating old users. this needs to be a CSV file
What would be the best to do this excell or access
What i see happening is getting a csv file, form our database stripping out all the unwanted feilds then uploading the users with that file (call this current users).
then when i get the next weeks file from the database i ll strip it to get all the feilds I want(call this for the moment new information).
Will this work (new information - current users) = new file with just new users on.
then (current users - new information) = new file with users that need deleting?
If this will work whats the best way of doing the compairing the 2 files.
Cheers