how to extract a dataset to the active cell?

  • Thread starter Thread starter NA_AB
  • Start date Start date
N

NA_AB

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

any help is very thankful...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel addin 2
VBA problem. 4
Extracting a number from a multiline-entry 9
Extract data from XML file and populate them into cells 1
Extract data from csv file 4
Help again!!! 1
Getting cell value from other sheets 2
copy from worksheet 3

Back
Top