how to extract a dataset to the active cell?

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...
 
S

Shane Devenshire

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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Problem activating pre-installed MS Office home and Student 0
excel addin 2
Macro to copy table of contents to a new doc 0
List all tables, including document structure 0
Extract data from XML file and populate them into cells 1
Extract name, address and ph# 8
VBA problem. 4

Top