I'm trying to find an easyer way to update the database on my webserver.
currently i open ten excell spreedsheets and refresh each one of them individualy, the sheets are linked to an external database, then i save each one as a .csv file. next i upload each .csv to the webserver and insert them in to the database. can anyone suggest a way in which i could speed this process up?
i would like to be able to link the webserver and the external database but its an old design and i cant find a linux driver to estblish the connection.
so any help with the ecell side of things would be great. some peice of software that will batch open, batch refresh, and batch save as.