As the OP asked, "What needs to be done here", and that's the question I
answered. (I'm starting to sound like a pedant)

As to the XLODBC add-in ...

http://www.bygsoftware.com/Excel/sqlrequest.html

Q: I can't find the XLODBC add-in. I'm using Excel 2002
A: This add-in is no longer included with Microsoft Excel. You can get it
from Microsoft by following this link -
http://office.microsoft.com/downloads/2002/xlodbc.aspx

Q: I can't find the XLODBC add-in. I'm using Excel 2003. I've tried the
above link but that says it can't find Excel 2002 or Excel XP.
A: This is where Uncle Bill isn't being too helpful :-( But, here is a way
to get to those files:
Open the xlodbc.exe using, say, Winzip.
Copy the files to a convenient location.
From within Excel, browse to the add-in file and load it as normal.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Peo Sjoblom" wrote in message
...
It's not built in though, as far as I know you need to install it and also
if
you have excel 2003 you need to find the 2002 version since it does not
come
with Office/Excel 2003 so given that, for the next version of office it
will
probably not work unless they include a new add-in


Regards


Peo Sjoblom


"Andy Wiggins" wrote:

You can!

... and here's how:

http://www.bygsoftware.com/Excel/SQL..._using_sql.htm

Using an UPDATE query in SQL.REQUEST to change values in closed
workbooks.
How to COUNT data in an Excel table and in an MsAccess database using
SQL.REQUEST.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Peo Sjoblom" wrote in message
...
You can't


Regards,

Peo Sjoblom

"Ali" wrote:

Hi, if someone can please tell me how I can add values to closed
excel
file
from an open excel file. What needs to be done here.


Thanks.