ANmarS - Search results

Excel/VBA expert since Sep 1997 (20 years 9 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with MySQL

Sat
Nov 12
2011

How do you insert external data into excel STARTER?

This question is specifically for Microsoft Excel STARTER. It's not like on other versions of excel where you have a data tab and can follow the steps from there.
I have already checked google also so please don't suggest pages on their or searching it on google. I have also checked the microsoft website.

BASICALLY, if you personally know how you insert data into Microsoft Excel STARTER I would really appreciate the steps on how to do it :) And will rate best answer for whoever tells me. Thanks


Answer

There are actually several ways, basically using VBA or macros
If you know how to do that there are several macros out there

I would suggest one of these
http://www.anmars.com/Work/?P=598866300
to read directly from MySQL DB into Excel sheet

or use
http://social.msdn.microsoft.com/Forums/…
to read from sql or Access

Also
http://www.bygsoftware.com/Excel/SQL/Usi…

Again, those are macros (Using the back door for Excel) to insert these data

If none of them helped, let me know from where are you inserting the data and I would be glad to show you the way.

let me know if that helped

Saturday 11/12/2011 2:17:09 AM

Tags

History