| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Import query from Access
Can you import queries from Access, with Excel? Right now I'm copying and
pasting my querry to Excel, and I was wondering if there's a better way. |
|
#2
|
|||
|
|||
|
I believe you can run the query straight from Excel using Data/Get External
Data/New Database Query and then select the Access database. Alternatively, you should be able to export the access query into an excel workbook. HTH PC "Kmarie" wrote in message ... Can you import queries from Access, with Excel? Right now I'm copying and pasting my querry to Excel, and I was wondering if there's a better way. |
|
#3
|
|||
|
|||
|
Check this link and see if one of those options works for you:
http://www.exceltip.com/exceltips.ph...ategory&ID=213 -- Regards, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| Removing Link to Access Query | Excel Discussion (Misc queries) | |||
| Link Access query to refresh an EXCEL file | New Users to Excel | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
