943,634 Members | Top Members by Rank

Ad:
Apr 29th, 2004
0

database update using excell

Expand Post »
Hi All,
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.

cheers

spikes
Similar Threads
Reputation Points: 11
Solved Threads: 2
Junior Poster
spikes is offline Offline
106 posts
since Jul 2003
Apr 4th, 2007
0

Re: database update using excell

Here are some things you might want to try.

There are plenty of open source readers for excel. You can try the Java API http://www.andykhan.com/jexcelapi/index.html. There are php readers out there that work a little better with databases and webservers, but you might need to do some digging to find them.

As for working with seperate sheets, you might want to consolidate them all into one book. This way when you hit save you save all ten sheets at once.

Once you get a reader working, all you then need to do is make a script or a file you can run from the command file that handles the connection from the webserver to the database.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
spincycle is offline Offline
6 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Windows NT / 2000 / XP Forum Timeline: Im having an issue deleting a program completely....
Next Thread in Windows NT / 2000 / XP Forum Timeline: Please help





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC