Publish Access Report to Sharepoint

[JimfromIndy]

I need to create a report in Access (2007), and then publish it (probably in .pdf format) to a Sharepoint Document Library.

Anybody face this one?

The report is a standard Access report based on a standard query. Only thing it does wierd is get its filter parameter from a text box on a hidden form.

Help!

 

[Trevor G]

JimFromIndy welcome to the forum,

In Access 2007 you can use MACROS to "TransferSharePointList". use the create tab and select macros on the right, then once in the macro window, you need to select to show all, then command above will be available to you, you can use Help at any stage then to finalise your request.

 

[JimfromIndy]

Good lead, but in vba (the docmd method), it appears the TransferSharepointList action will only Import or Link, not Export.

Is there a Sharepoint object I can instantiate to do this under the covers? Remember, my objective is to deliver a snapshot report (with a name that identifies it) as a member of a Sharepoint Document Library. I don't want to transfer the data or create a dynamic report.

My fallback is to create a view and export the static data (I want static data, NOT dynamic data) as the Document Library entry. That would be confusing, though, since it wouldn't be identical to the report.

Any other ideas?

 

[Trevor G]

Follow this link as there is information from Microsoft about Export

http://msdn.microsoft.com/en-us/library/aa159897(office.11).aspx