•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,433 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,664 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 9164 | Replies: 3
 |
•
•
Join Date: Jul 2005
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
how to update data in mysql table using data from an excel table 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
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:
Rep Power: 4
Solved Threads: 0
Light Poster
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
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:
Rep Power: 0
Solved Threads: 0
Newbie Poster
has anyone already written a program that does this that i could use?
•
•
Join Date: Jun 2005
Location: Kansas City, Missouri, USA
Posts: 344
Reputation:
Rep Power: 4
Solved Threads: 4
Posting Whiz
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.
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.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access breach broadband code combo crime daniweb data data protection data transfer database drive dropdownlist forensics government gpt guid partition table hard hardware hitachi internet linux microsoft windows module net news partition reuse security skype storage terabyte vista updates voip web wikipedia windows update windows vista
- retrieving a single cell of data from a MySQL database (PHP)
- Inserting uft8 strings into MySQL from jsp page (JSP)
- Help With Messages in Mysql Stop Overwriting (MySQL)
- Automate Data from text file into MySql table? (MySQL)
- mysql < CSV < mydql (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: Random unique primary key - is this possible?
- Next Thread: Project help with database
