View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jef S[_2_] Jef S[_2_] is offline
external usenet poster
 
Posts: 1
Default how to add database values to a specific cell

I put this one line of code in my Visual Basic ActiveX Script Task, and that
is it?
That will be outstanding!!!
Thanks Tom. Thanks for the speedy reply as well.


Jef

"Tom Ogilvy" wrote:

worksheets("Sheet1").Range("B9").Value = variableValue

--
Regards,
Tom Ogilvy


"Jef S" <Jef wrote in message
...
I am building a report using DTS Packages. The data resides on a PSQL

server.
What I want to do is take the results of a value in a table and put it on

an
Excel spreadsheet in a specific cell. What I have found are ways of taking
information from the spreadsheet and putting it into an Access Database.

How can I go from the database to a specific cell in a spreadsheet?


Thanks in advance for your help,