:(

[LTF]

Updating a 5000+ strong database record by record...

A fate worse than death?





Ver possibly...

Jus thought id share that

 

[kanonfodda]

I feel for you mate, not fun doing that kind of thing

/me hands D0nk3h a spotty work experience assistant

here mate, let him take all the flak

:0)

 

[Summo]

Surely there's an automated way of doing that? I bet you're entering them from a printout. Can't you persuade whoever sourced the data to let you have an electronic copy?

Eh? EH?

 

[Testin da Cable]

drop table *
wasn't that it?
/me hates databases

 

[LTF]

Theyre all reps for a nationwide company.

Some have joined, some left, some married ALL have changed territory numbers (their work areas) since the territories were relocated. THere is no other way.... oh the pain and ive only done 300 (ish)

Work experience is done just before summer holidays isnt it?!

 

[Summo]

*design OCR data extraction routine*

*write database integration procedure*

*launch*

Time for a ciggy, I think...

 

[kanonfodda]

So?

Find a spoty oik, tell him you will pay him and then sod off down the pub.

Failing that, get an electronic version (ala Summo) and run an update query to amend all the existing ones, an append to add the new ones, and a delete query to remove the old ones.

30 secs, database fixed, tell the boss it will require days, then take the petty cash for a holiday to the nearest pub

Everyone's a winner

what sort of database is it? (SQL, Oracle, etc)

 

[LTF]

Plan D:

Sickie for rest of week ala summo

 

[Summo]

I strongly recommend it.