SharePoint Document Issues

How to Export an Access Report as a PDF to SharePoint

Tauseeq Magsi Oct 9, 2026 869 views

Question details

The user wants to save an Access report as a PDF directly to a SharePoint document library, potentially using VBA.

How to Export an Access Report as a PDF to SharePoint

Product: Microsoft Access and SharePoint
Device & OS: not provided
Scenario: Attempting to export a database report from Access as a PDF file into a SharePoint document library.
Observed behavior: The native SharePoint export option in Microsoft Access is disabled or meant for lists, preventing the direct saving of a PDF report to a document library.

Before you start

Ensure you have the necessary write permissions for the target SharePoint document library and verify that you can manually upload files to the folder via your web browser.

Solution 1Recommended

Manually Export to PDF and Upload to SharePoint

The built-in SharePoint export feature in Access is designed for exporting data to SharePoint lists, not for generating PDF files. The most reliable method is to export the PDF locally and then upload it.

Because Microsoft Access does not support direct PDF exports to SharePoint document libraries through the native 'Export to SharePoint' button, saving the file to your local drive first is the standard workaround.

Export the report as a PDF

Open your Microsoft Access database and run the report. Navigate to the 'External Data' tab on the ribbon and click on the 'PDF or XPS' button in the Export group. Save the file to your local Desktop or Documents folder.

Open your SharePoint library

Open your web browser, navigate to your SharePoint site, and click on the specific Document Library where you want to store the report.

Upload the PDF file

Click the 'Upload' button at the top of the SharePoint library, select 'Files', browse to the local folder where you saved the PDF, and select the file to upload it.

Manually Export to PDF and Upload to SharePoint

Syncing with OneDrive: If you have synced the SharePoint document library to your computer using the OneDrive sync client, you can export the PDF directly to the synced folder in Windows File Explorer.

Solution 2

Automate PDF Export and SharePoint Upload using VBA

You can use a VBA script to automate the process of generating the PDF and uploading it directly to the SharePoint URL or mapped network drive.

Free Microsoft Office alternative

Discover WPS Office for Seamless Document and PDF Management

While Microsoft Access often requires complex workarounds like VBA scripting for simple PDF exports, WPS Office provides a lightweight, intuitive suite for managing all your Word, Excel, PowerPoint, and PDF files. Enjoy a seamless experience for viewing, editing, and sharing your exported PDF reports.

1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
2. Manage your PDFs: Open WPS PDF to effortlessly read, annotate, or edit the reports you exported from your database.

Fully compatible with Microsoft Office formats (docx, xlsx, pptx)Powerful built-in PDF toolkit for editing, annotating, and convertingFree and lightweight suite with a familiar, user-friendly interfaceSeamless file sharing and cloud collaboration without complicated setups

microsoft office alternative - wps office

Frequently Asked Questions

Why is the SharePoint export option disabled or not working for PDFs in Access?

The built-in 'Export to SharePoint' feature in Microsoft Access is designed specifically to export database tables and queries into SharePoint Lists. It is not engineered to convert and save printable reports as PDF files into document libraries.

Can I map a SharePoint document library as a network drive to save PDFs directly?

Yes, mapping a SharePoint document library as a network drive in Windows allows it to act like a local folder. Once mapped, you can bypass manual uploads and use the standard 'Export to PDF' function in Access to save files directly to that drive path.

Is it possible to use Microsoft Power Automate instead of VBA for this task?

Yes, instead of writing VBA code, you can export your PDF to a specific local folder or a OneDrive folder. You can then create a Power Automate flow that monitors that folder and automatically copies any new PDF files to your SharePoint document library.

Document & File Issues