URGENT ADVICE REQUIRED :)

J

Jamie French

Hi Guys,

I wondered if anyone can offer advice/help regarding my dissertation
project. Basically we are currently using an excel workbook which contains
worksheet for each use to record working time. I have to provide an
solution that allows concurrent user access where the data entered is stored
in a database for aggregation for use in sql server and analysis services.

Could I still use excel to do this?
If the workbook is shared, are there any issues between Excel 2000 and 2003
to its use?
Can the shared workbook be represented on a website?
Can worksheets be hidden from other users?

I appreciate your time and thank you in advance. Even if you don't respond
to my questions, perhaps a link where to read about would be good.

Take Care,

Jamie
 
O

onedaywhen

Jamie French said:
Hi Guys,

I wondered if anyone can offer advice/help regarding my dissertation
project. Basically we are currently using an excel workbook which contains
worksheet for each use to record working time. I have to provide an
solution that allows concurrent user access where the data entered is stored
in a database for aggregation for use in sql server and analysis services.

Could I still use excel to do this?
Click to expand...

If you've got SQL Server, better to use that to store the working time data.

--
 
J

Jamie French

This was an intention, thus using the excel timesheet as a form rather than
the repository.

Thanks,

Jamie

onedaywhen said:
"Jamie French" <jamie_french@[no spam]aimtechnology.com> wrote in message
Hi Guys,

I wondered if anyone can offer advice/help regarding my dissertation
project. Basically we are currently using an excel workbook which contains
worksheet for each use to record working time. I have to provide an
solution that allows concurrent user access where the data entered is stored
in a database for aggregation for use in sql server and analysis services.

Could I still use excel to do this?
Click to expand...

If you've got SQL Server, better to use that to store the working time data.

--
Click to expand...
 
A

aaron.kempf

throw away excel and use Access for this

Access Data Projects are a wonderful tool for getting data into SQL
Server and out of SQL Server.. adn you can make it pretty !!!
 
K

Ken Wright

Another fictitious reply to a non-existent post just to get a rant into the
newsgroups - Petty beyond belief.
 
Top