Home |
Search |
Today's Posts |
#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 |
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) |