View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ladyhawke ladyhawke is offline
external usenet poster
 
Posts: 23
Default read string from database and divide result into cells?

I would like to read a string based on a db query (like select Names
from NameTable where Name Like '%James%') and take each resulting
string and devide then into different cells...

E.g. James Hansson - A1=James and B1=Hansson

How can this be done? I can get as far as using querytables and show
the results in the current sheet but thats not what I want.

//Ladyhawke