Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Running an UPDATE query from Excel to update a db table

  Asked By: Ayden    Date: Nov 14    Category: MS Office    Views: 1034
  

I get data in Excel that I want to put into a mysql
database (I have ODBC installed)... How do I run an
update query from Excel and is it possible?
So far I only found references on how to select stuff
INTO excel, not how to export it...
I can theoretically save the file as comma-delimited
and then import it into mysql for example, but I am
looking for a direct update between Excel and mysql
(VBA & ODBC)

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Running an UPDATE query from Excel to update a db table Or get search suggestion and latest updates.




Tagged: