R
Redpelon
Ok here is the situation: I'm trying to fix the data entry at my
office, and there is a spreadsheet that they have been using here to
keep track of data. On the spread sheet, they put the persons last
name, first name, city and then the date they came in here and the
name of the referring agency and caseworker. What they have been
doing for years is each time the client would come in, they would just
add a line to the excel spreadsheet, using the same last and first
name, and then just put in the new referring agency or caseworker and
date they came in.... im trying to find a way to split this all up and
somehow make it into an access DB but am baffled on how to extract the
correct data - I want to be able to eliminate all the duplicate names,
and then create a different table (or tables) to store the information
about which agency referred them for this visit, etc. Just in 2008
alone there are close to 3000 records in the spreadsheet so I dont
really feel like going in and fixing that part up.. i am just
wondering if anybody has a creative way to perhaps work with the
spreadsheet to extract and then link correctly..
I have tried importing the spreadsheet with only first and last name,
and then importing it again omitting first and last name, yet keeping
the rest of the information.. I think created a relationship between
the two based on autonumber and they would at least match with the
correct information, but there would still be three entries for john
smith, and each entry would be correctly linked to each john smith
visit...
any ideas? thanks in advance
red
office, and there is a spreadsheet that they have been using here to
keep track of data. On the spread sheet, they put the persons last
name, first name, city and then the date they came in here and the
name of the referring agency and caseworker. What they have been
doing for years is each time the client would come in, they would just
add a line to the excel spreadsheet, using the same last and first
name, and then just put in the new referring agency or caseworker and
date they came in.... im trying to find a way to split this all up and
somehow make it into an access DB but am baffled on how to extract the
correct data - I want to be able to eliminate all the duplicate names,
and then create a different table (or tables) to store the information
about which agency referred them for this visit, etc. Just in 2008
alone there are close to 3000 records in the spreadsheet so I dont
really feel like going in and fixing that part up.. i am just
wondering if anybody has a creative way to perhaps work with the
spreadsheet to extract and then link correctly..
I have tried importing the spreadsheet with only first and last name,
and then importing it again omitting first and last name, yet keeping
the rest of the information.. I think created a relationship between
the two based on autonumber and they would at least match with the
correct information, but there would still be three entries for john
smith, and each entry would be correctly linked to each john smith
visit...
any ideas? thanks in advance
red