Excel as database interface ?

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

It is possible to make something like that:
On save user saves spreadsheet on HD and data are send to database, next
time when they open the file they take data from database instead of
fixed data ?
 
Hi
though you could achieve such things with VBA why not use a database
directly (also for entering your data). Would be much simpler
 
Piotr said:
couse my users must follow ISO standard and they have their ISO Excel
sheet ;-(
Click to expand...

Hi

Two big problems then:
- Excel is a rows-columns-thing, well suited for single tables. Good
databases are relational, where multiple tables are linked together and what
you see may well be a product of many tables. Excel has no built-in ways to
tell what goes where if so.
- What if several users edit or delete/keep the same information
simultaneously and updates are to happen at Save, then what ?

So second Frank; yes it can be done, but it is awkward to make and at its
best not very good to use. A full userforms - VBA solution can certainly
make a great database frontend for smaller operations, but that is a poor
man's VB solution with little use of Excel herself.

HTH. Best wishes Harald
 
Hi
to re-second Harald: it would be much easier to fulfill that standard
(whatever you mean with 'ISO Standard') with a small database frontend.
Especially if multiple users should enter data (at the same time) all Excel
solutions are really complicated and/or not very stable/scalable.
 
Back
Top