View Single Post
Newbie Member
12Jun2008,22:59  
Das2008's Avatar
Hi Siko,

Can we do this(Transferring multi-column query result into MS Excel) with out using VBA & merely in Excel ?

I need to populate values(from Oracle) in to column B's each cell referencing column A's each cell.

I must use references of all cells of column 'A' & get values to corresponding cells of column 'B'. I am able to create parameter query for one cell at a time!

Using VBA is restricted, thus I'm looking for a way to do it in merely excel.
Please advise me the best way to solve this.

Thanks,
Das