| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to keep Excel sheets on a database?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database extract having 3 common cell betwenn sheets | Excel Worksheet Functions | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Editting xml format sheets stored in database. | Excel Discussion (Misc queries) | |||
| Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
| Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
