Re: Link excel to a query?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Linda,

Check out Excel's Data|Import External Data options.

On Mon, 27 Feb 2006 21:08:30 -0500, "LMB" <RomulanQueen@xxxxxxxxxxxxxxx>
wrote:


Hi Everyone,

I update our department website once a month. This website is on an
intranet and basically I browse for the document I want to put up there and
a copy is made and uploaded to the website. I have a crosstab query that I
copy and paste onto an excel *** every month to upload to the website.
Now I have to update 3 facilities and wondered if I could link an excel
*** to my crosstab query so it updates as often as the query would to
avoid having to open the database, navigate to the query, then copy and
paste. I have also been asked to do it more often so the time it takes is
starting to add up. I can't link from the website only upload a copy. I am
using Office 2000.


Thanks,
Linda



--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

.

Quantcast