Data manipulation

[hargi]

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

 

[JIMA]

Hi,

I'd tackle this by loading the data into tables on a database and then using SQL to compare the sets of data.

The current information will be held on a table. Read the new information into another table (or a temporary table if the database supports this). You can then compare the two sets of data, getting matching users, users in one set but not the other etc, This will also allow you to extract the fields that you want and to perform updates/deletes with the sets of data retrieved e.g deleting old users.

Hope that helps.

Jim

 

[hargi]

Cheers Jim,
Do you have the SQL to do that?