View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PerryK PerryK is offline
external usenet poster
 
Posts: 19
Default importing/linking data from an Access 2003 Query to an Excel 2003

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