Distributed Data Collection Tool

[minestrone]

Just leave the file in a shared folder and say that the only person that can edit it is the one that holds the wooden spoon, then leave a wooden spoon on your desk with 'edit' written on it.

If they want a ridiculous solution give them a ridiculous solution.

[d000hg]

If everyone saves their spreadsheet as CSV, gluing them together is pretty easy.

But then, pulling data from spreadsheets into a DB wouldn't be too bad either.

[vetran]

Sharepoint?

[rob s]

Sharepoint?

Pretty much the only time sharepoint has any use.

[meridian]

Distributed Data Collection Tool

If everyone saves their spreadsheet as CSV, gluing them together is pretty easy.

But then, pulling data from spreadsheets into a DB wouldn't be too bad either.

Ah, if only it were this easy! Tried this on data collection before, didn't count on the ones that wanted to add their own columns, insert empty rows, add colours and then send me an email with their colour codes and what they meant, and so on.

OP: Excel front end onto an Access database? http://www.datawright.com.au/excel_r...ss_and_ado.htm

[d000hg]

Ah, if only it were this easy! Tried this on data collection before, didn't count on the ones that wanted to add their own columns, insert empty rows, add colours and then send me an email with their colour codes and what they meant, and so on.

That's why you lock the sheet down

[vetran]

Pretty much the only time sharepoint has any use.

keep thinking that way ! more for the rest of us.