Connecting SQL and Excel "Meena" <meena[ at ]chellasoft.com> 21.08.2006 05:52:51 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

Re: Connecting SQL and Excel "Nick Hodge" <nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS> 22.08.2006 20:35:51 Meena Check here http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm#Using_Parameters_In_External_ODBC_Data_Queries -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT[ at ]zen.co.uk.ANDTHIS www.nickhodge.co.uk "Meena" <meena[ at ]chellasoft.com> wrote in message news:uj%238HZOxGHA.5044[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > 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 > > >