excel 2010 addin and vba connect create and insert into db
Posted by: Joshua Serry
Date: December 13, 2013 01:35AM

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

Options: ReplyQuote


Subject
Written By
Posted
excel 2010 addin and vba connect create and insert into db
December 13, 2013 01:35AM


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.