reading database value into a cell
 

Hello:

It's possible than I assing a datasource value into an especific cell?

ex. cellA1.text=TableSource.CompanyName


thanks and regards

Xabi

reading database value into a cell
 

i don't think u can
u need a databaseconnection (through odbc, ...) to access th
database.
You could use the function 'get external data' in the data menu.
It gives you a wizard, follow the steps to access the database, you ca
then make the query you need (i.e. select name from personsTable) an
sent the result back to excel

--
schuurke2
-----------------------------------------------------------------------
schuurke28's Profile: http://www.excelforum.com/member.php...fo&userid=1581
View this thread: http://www.excelforum.com/showthread.php?threadid=27315

reading database value into a cell
 

Hello schuurke28:

Thanks by your answer :).

The problem is that I have twenty fields in my table and this way looks
like heavy.

Is not any way to do this? cell.text=table.name or near?

thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!