![]() |
getting data from access to exel
How can I get data from an access query (just one cell) to excell?
bill |
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