Export Excel spreadsheet to MySQL

S

Sarah

I have an MS Excel spreadsheet that I work with. I have no MySQL
knowledge, but I need to load this Excel data into MySQL. I would like
to develop a VBA procedure to do this so that I can click a button in
Excel any time I make changes to the spreadsheet and it will load the
changes into the MySQL database on the back end. I must make the
changes in the Excel spreadsheet; I can't just load the date to MySQL
and maintain it there. Any help would be appreciated. I have a tool
called "Query Tool (using ODBC) 3.4" that is connected to the MySQL
database, but that's about the extent of my knowledge.

Thanks in advance,
Sarah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top