| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Get records from a query in access and put them in Excel
Open your Database.
Go to Queries. Click on the query you want sent to Excel. In the Main Menu, go to File--Export Select where you want it saved and MOST IMPORTANTLY select the version of Excel you want to use from the drop down menu labeled "Save as type:" at the very bottom of the window. Click "Save". Ta-Daaa! - Pikus  --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Deleting records from access using ADO in through Excel | Excel Programming | |||
| Access records updating from Excel. | Excel Programming | |||
Linear Mode
