reading database value into a cell

[Xabi]

Hello:

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

ex. cellA1.text=TableSource.CompanyName


thanks and regards

Xabi

 

[schuurke28]

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

 

[xabi lorente]

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