MySQL Forums
Forum List  »  Microsoft Access

Automatically update MYSQL database from excel sheet on weekly basis
Posted by: Megha Gupta
Date: June 02, 2011 07:52AM

Hello people,

I have my MYSQL database and two excel sheets placed in shared drive of our company.
MYSQL database has table which contains exact fields as both excel sheet do . what I want to do is pick one particular column from one excel and another columns from second excel shhet and update those columns (two from two sheets in one table of DB) only in MYSQL database . I want to make this process automatic on weekly basis.
Is there any way to connect MYSQL to two seprate excel sheet adn update one table automatically provided the condition is Excel sheets are in shared drive and MYSQL database is situated on different server.

Please advise !!!

Thanks a bunch

MG

Options: ReplyQuote


Subject
Views
Written By
Posted
Automatically update MYSQL database from excel sheet on weekly basis
10961
June 02, 2011 07:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.