Access data to Excel

[Bertrand82]

Hi, I need some ideas.



I have created a query with some fields and rows. I would like to export this data to an location on a sharepoint server.

I would then like some managers to create a link from local excel-documents to this file so that they can create som pivot tables.

When I update the query each month and export it to the sharepoint location. All the managers need to to do is to "refresh" their pivot table for current data.

Any suggestion of best practical arrangement and export and import file format?

Br Bertrand.

[NTC]

Access of course easily exports to excel. And one can select any folder any where on your permitted LAN - which includes your sharepoint server.

Perhaps you have a more complicated situation that I see from your post,

[Bertrand82]

When trying to export to a sharepoint server it says.

"Only XML files can be exported to an internet adress (http://,ftp://). Enter a path that points to a location on your computer or on the network."

[Bertrand82]

solved with xml and data connections in excel