ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   getting data from access to exel (https://www.excelbanter.com/excel-programming/293893-getting-data-access-exel.html)

Bill McCaleb

getting data from access to exel
 
How can I get data from an access query (just one cell) to excell?

bill


NicoB

getting data from access to exel
 
Your Access query must return a single value
Menu : Data Get External Data New Database Query..
In the Dialogbox click on the Database page (default) and select "MS Access Database" and click "OK"
In the next dialog box select the location of your database (.mdb). The another dialogbox is opened containing the list of available tables and queries of your database. Then select your query and follow the steps of the wizard
When finished, you have in the Data menu a new option to "Refresh Data".


All times are GMT +1. The time now is 11:45 PM.

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