How to keep Excel sheets on a database?

P

Phil S

We have a large and complex spreadsheet in use by tens of workers,
each one keepiing a standard sheet for a different company. The
supervisor would like to be able to see these spreadsheets and has
asked is we could keep them on an Access DB on the LAN server where
she could access them from Excel.

I'm an experienced Java and C developer, new to MS Office and VBA.
What is the best way to accomplish this? Can I use an Access DB over
the LAN? Do we need to use a MS SQL server?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top