Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting data from access to exel
How can I get data from an access query (just one cell) to excell?
bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Sort #ERR in copied data - Exel 2003 | Excel Discussion (Misc queries) | |||
can Excel import access that has tables linked to exel? | Excel Discussion (Misc queries) | |||
how do I convert a non exel tabulation to exel | New Users to Excel | |||
Exel Data Entry | New Users to Excel | |||
how do I compare data in Exel spreadsheets? | Excel Discussion (Misc queries) |