Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading Cell Address in VBA Richard Excel Discussion (Misc queries) 2 April 15th 08 06:33 PM
Reading a cell in VBA Ruatha New Users to Excel 3 June 11th 06 04:01 PM
Reading last cell jackh7777777 Excel Discussion (Misc queries) 2 May 26th 06 01:28 AM
Reading data from a database Richard Buttrey Excel Programming 1 August 13th 04 03:13 PM
Reading with ADO from Access database over network onedaywhen Excel Programming 1 April 2nd 04 12:29 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"