Group:  Microsoft Excel ยป microsoft.public.excel.querydao
Thread: Integrating SQL And Excel

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Integrating SQL And Excel
"NewsGroup" <menna[ at ]chellasoft.com> 18.08.2006 05:51:36
This is my task.

(eg) :
My SQL Server 2005 resides in a seperate system and Excel 2003 application
in another system.
My SQL DB contains a table called "Employee" with fields Id, Name, Salary...
When I enter an Id in the Excel Sheet, I should get the remaining data
filled in the other columns.
How do I establish the connection and write the query for this?
Ca anyone guide me to this task?

Meena



Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net