using Excel to connect to external data source

Hello everyone,


I am learning how to use Excel to connect to other external data source (like database). What I want to do is to develop a plug-in for Excel and automatically access external data source, then display it in Excel tables.

Are there learning resource? I have tried to search in MSDN, but can not find any learning resources.


thanks in advance,
George

have you read this http://msdn2.microsoft.com/en-us/lib...6d(VS.80).aspx ?

Hi vart,

Quote:

---

Originally Posted by vart

have you read this http://msdn2.microsoft.com/en-us/lib...6d(VS.80).aspx ?

---

Are there any articles dedicated to Excel programming to retrieve data from external data source? I can not find one from the link you recommended. Thanks.


regards,
George

This http://msdn2.microsoft.com/en-us/lib...ew(VS.80).aspx seems to be what you are looking for

Good stuff, thank you vart!

Quote:

---

Originally Posted by vart

This http://msdn2.microsoft.com/en-us/lib...ew(VS.80).aspx seems to be what you are looking for

---

regards,
George