Advertisement

05.15.2008 at 10:48AM PDT, ID: 23406059
[x]
Attachment Details

How can I update a MySQL table with the values of some cells in Excel?

Asked by SitelBabe in MySQL, Microsoft Excel Spreadsheet Software, VB Script

Tags: VBS, command line // automatisation

Hi,
I'm currently working on a scheduled task, that's why I'm using the VBS.
I need to do the following:
I receive an Excelfile (XLS) with accountnumbers in.
I need to update my mysql table and put "tblCalled" to 4 where the accountnumber is in the excelsheet.
I've been looking for a couple of weeks now but nothing so far...Start Free Trial
 
Keywords: How can I update a MySQL table with t…
Title
1 setting MYSQL rules
2 xls to mySQL
3 Problems creating a MySQL Stored Pro…
4 How to backup MySQL securely
5 Automated MYSQL backups
6 Congratulations angelIII - new MySQL …
 
Loading Advertisement...
 
[+][-]05.15.2008 at 10:39PM PDT, ID: 21580250

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.16.2008 at 12:24AM PDT, ID: 21580587

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 04:16PM PDT, ID: 21594423

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.18.2008 at 07:10PM PDT, ID: 21594871

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL, Microsoft Excel Spreadsheet Software, VB Script
Tags: VBS, command line // automatisation
Sign Up Now!
Solution Provided By: JesterToo
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628