Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am attempting to link an Access Query to an Excel file, so I can update the
data in the Excel file each month, without having to copy and paste it from Access. The help file suggests the following steps--- "Data" - "Import External Data" - "Import Data". It allows me to Browse to my Access file, but it only lists the "Tables" not the "Queries". How do I get to the "Queries" using this method, or is there another way to link the data to the Excel File? Thanks in advance for any help with this! -- Perry K |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Perry,
If there are truely queries in the db you should be able to see them in the Select Table window. You may have to scroll to see them. I tried this on a db I've created and was able to see the queries. If not, the other thing you can do is: (Excel 2003) 1. Select Data from the menu bar 2. Select Import External Data 3. Select New Database Query... AND follow the prompts. This method should allow you to create a custom query based on the table(s) you select. This is a good method if you are comfortable with creating queries. If this helps, please press Yes. JCS "PerryK" wrote: I am attempting to link an Access Query to an Excel file, so I can update the data in the Excel file each month, without having to copy and paste it from Access. The help file suggests the following steps--- "Data" - "Import External Data" - "Import Data". It allows me to Browse to my Access file, but it only lists the "Tables" not the "Queries". How do I get to the "Queries" using this method, or is there another way to link the data to the Excel File? Thanks in advance for any help with this! -- Perry K |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Perry,
If you look at Bud Cookson"s later post (Getting query data from Access posting), he describes the same issue you are having. He discovered that if the queries have parameters associated with them, the queries will not display. Hope this helps! Please press Yes if it did. JCS "PerryK" wrote: I am attempting to link an Access Query to an Excel file, so I can update the data in the Excel file each month, without having to copy and paste it from Access. The help file suggests the following steps--- "Data" - "Import External Data" - "Import Data". It allows me to Browse to my Access file, but it only lists the "Tables" not the "Queries". How do I get to the "Queries" using this method, or is there another way to link the data to the Excel File? Thanks in advance for any help with this! -- Perry K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing data in excel 2003 | Excel Discussion (Misc queries) | |||
opening excel files from access 2003, win xp, office 2003 | Excel Discussion (Misc queries) | |||
Importing data into Excel 2003 from a Web site | New Users to Excel | |||
Importing data into Excel 2003 from a Web site | Excel Discussion (Misc queries) | |||
MS Query - from Access 2003 to Excel 97 | Excel Discussion (Misc queries) |