Access Link to Excel

B

Bruce

Is it possible (Office 97) to Link an Access Query to an Excel File. What I
am trying to do is incorporate the filtered Access data into a Chart in
Excel.


Best Wishes
Bruce
 
D

Duane Hookom

Sure, you can use Data->Import External Data->New Database Query and create
a link to your query. Keep in mind that some function that work in the
Access environment won't translate in Excel such as Nz() and any of your
user-defined functions.
 
Top