Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default how to extract a dataset to the active cell?

how to display the entire table extracted from the database onto the active
cell of excel sheet???

any help is very thankful...
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default how to extract a dataset to the active cell?


???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"NA_AB" wrote in message
...
how to display the entire table extracted from the database onto the
active
cell of excel sheet???

any help is very thankful...


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 857
Default how to extract a dataset to the active cell?

Hi,

You can't put an entire database table into a single cell.

If you want to make a connection to an external Access table for example,
you can use the Data, Import External Data, New Database Query or
technically a PivotTable.

If this helps, please click the Yes button.

cheers,
Shane Devenshire

"NA_AB" wrote in message
...
how to display the entire table extracted from the database onto the
active
cell of excel sheet???

any help is very thankful...


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
Extract all CN='Name' from a Active Directory data-dumped-cell mateo561 Excel Programming 7 December 7th 06 08:32 AM
Extract Data From Active Directory Adrian Excel Programming 1 August 23rd 06 11:44 PM
assign dataset to matching dataset Michael Dirksen Excel Programming 0 June 16th 06 04:34 PM
How to extract just the Column Name of the active cell Fred Excel Discussion (Misc queries) 4 December 8th 05 06:24 PM
Converting A Quarterly Dataset to Weekly Dataset Dan Thompson Excel Programming 5 November 25th 05 09:27 PM


All times are GMT +1. The time now is 10:07 PM.

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

About Us

"It's about Microsoft Excel"