Using Access with Excel

[SlinkRN]

I'm working on a scheduling program and I'm wondering how advantageous it would be to use access with excel instead of just making a database page in Excel that links to other sheets in the same workbook. I haven't worked with access yet, so I'm not sure what advantages it has to offer. I'm thinking access would hold employee names and full-time status, vacation days taken, etc. but it would have to get information from the schedule in excel about vacation days taken.
Is it best to just keep all information in one program (excel)?
This message was edited by SlinkRN on 2002-12-12 10:55

 

[paliman]

I've made an accounting aplication myself that combines access with excel. I decided to use access because I needed a relational database and this could not be done in excel. In my case I have to relate one invoice with many items sold in that invoice. So, I keep all my data in access and get it to excel via the option "get external data"
Excel provides an excelent output, since it's an excelent analysis tool. I use it to get my customer's balances and a cashflow.

Anyway, I think that if you don't need a relational DB you can keep it all in excel.

Just my opinion. I would like to read someone else's as well.