excel 2010 addin and vba connect create and insert into db
Hi All,
I have three questions.
Q1. I cannot get the excel 2010 addin to work I have reinstalled 10 times. it always as com addin???
please help this sounds like a really useful feature, is there any videos showing how to use it once someone tells me how to get it working? Can't find any?
Q2How do you write excel vba to programmatically
2.1. connect to mysql server? and how to get connection string?
2.2 create sql database?
2.3 create table in sql database?
2.4 create query on tables in sql db using vba
2.5 loop through all fields and records in a db to compare them against a list and see if they exist?
2.6 delete the db to create it again?
2.7 check if the db exists before deleting it?
I can do all this using MS SQL but I need to know how to do it using mysql so I can put the information into a mysql database online
Subject
Written By
Posted
excel 2010 addin and vba connect create and insert into db
December 13, 2013 01:35AM
December 17, 2013 10:28AM
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.