ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to extract a dataset to the active cell? (https://www.excelbanter.com/excel-programming/421694-how-extract-dataset-active-cell.html)

NA_AB

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

Don Guillett

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



Shane Devenshire

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




All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com