Importing data from an Access db
We run SIMS, however there are a number of small Access databases in various admin depts that have been cobbled together over the years (prior to my recent arrival) that seem to replicate functionality that is (nowadays, at least) available in SIMS.
I'd like our staff to all use SIMS; any pupil-related data should be held on one DB, not a random collection of db's sitting on single machines!
Any ideas on how I can easily import accumulated data from Access into SIMS? Medical info is the prime example at present but I'm aware of at least one other db that should not exist outside SIMS.
I was thinking of storing info as documents on the SIMS document server as a workaround but this is far from ideal and will likely alienate the end user(s). Much better to have relevant info stored in the correct part of SIMS, i.e. a pupil's medical info section.