MySQL

how to update data in mysql table using data from an excel table

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2005

Posts: 6

Reputation: escolta is an unknown quantity at this point

Solved Threads: 0

escolta

Offline

Newbie Poster

how to update data in mysql table using data from an excel table

Aug 1st, 2005

i get an excel report each month,

There are two columns (person`s name and Salary)
in this month report there was 99 persons.

my question is , if in next month excel report there are less persons...say 75, and also 23 persons raised their salary..

how can i updatae this changes in a mysql table that i have this mysql table has the exact same two columns and the exact same information i have in excel...

is there a way to do this?

Please help

•

Join Date: Jun 2005

Posts: 28

Reputation: proghelper is an unknown quantity at this point

Solved Threads: 0

proghelper proghelper is offline

Offline

Light Poster

Re: how to update data in mysql table using data from an excel table

Aug 3rd, 2005

Do you want the whole process to be automated?

If that is the case, you could use the Excel API and convert the Excel file to some program understandable text format and write a program to extract and write the info to the database.

------------------------

Programming ( Assignment / Project ) Help

•

Join Date: Mar 2006

Posts: 1

Reputation: randi is an unknown quantity at this point

Solved Threads: 0

randi

Offline

Newbie Poster

Re: how to update data in mysql table using data from an excel table

Mar 24th, 2006

has anyone already written a program that does this that i could use?

•

Join Date: Jun 2005

Posts: 354

Reputation: Troy is an unknown quantity at this point

Solved Threads: 5

Troy

Offline

Posting Whiz

Re: how to update data in mysql table using data from an excel table

Mar 24th, 2006

Yes, you can script a solution. The question then is, what programming languages are you comfortable with? If you are not a programmer, then you need to find one.

You can use ODBC drivers to connect directly to an Excel file. You can then iterate the rows just like a normal SQL table. So your code would iterate the rows in Excel, and update the MySQL db as necessary.

Once you know what language you prefer to use, you should post in the appropriate programming forum--your question is really a programming question, not a database question.

Troy Wolf is the author of SnippetEdit. "Website editing as easy as it gets." IX Web Hosting