How to Link an Excel File Stored in OneDrive to Microsoft Access
Question details
The user needs to use an Excel workbook stored in OneDrive as a linked data source within Microsoft Access.

- Product
- Microsoft Access, Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Attempting to connect a cloud-stored Excel workbook to an Access database to utilize linked data.
- Observed behavior
- Microsoft Access cannot connect directly to a cloud-only OneDrive location or URL; it requires a local file path to establish the connection.
Ensure you have the Microsoft OneDrive desktop application installed and that the target Excel workbook is fully synchronized to your local computer drive.
Link via the Locally Synchronized OneDrive Folder
Use the OneDrive desktop application to create a local copy of your file, which Microsoft Access can successfully link to.
Microsoft Access does not support direct connections to cloud-based URLs for linked tables. By utilizing the OneDrive desktop app, a local folder is created on your C: drive that constantly syncs with the cloud. Access can easily read from this local folder while OneDrive handles the cloud synchronization.
Download and install the OneDrive desktop application on your PC. Sign into your account and allow your files to synchronize to your local drive.
Verify that your Excel workbook is visible in your local OneDrive folder, typically located at C:\Users\[YourUsername]\OneDrive.
Open your database in Microsoft Access. Navigate to the 'External Data' tab on the ribbon, click 'New Data Source', select 'From File', and then choose 'Excel'.
In the Get External Data wizard, click 'Browse' and navigate to the local OneDrive folder to select your Excel workbook.
Select the option 'Link to the data source by creating a linked table' and click 'OK'. Follow the remaining prompts in the wizard to finalize the link.

Looking for a Lightweight Excel Alternative?
While Microsoft Access requires specific local file paths for linking databases, managing and editing your spreadsheets doesn't have to be complicated. WPS Office provides a free, highly compatible alternative for all your spreadsheet tasks with built-in cloud synchronization.
- 1. Download WPS Office: Install WPS Office for free on your Windows, Mac, or Linux device.
- 2. Open Your Spreadsheets: Directly open your existing .xlsx or .csv files in WPS Spreadsheet without any formatting loss.
- 3. Sync to Cloud: Enable WPS Cloud to automatically save your work and access it from anywhere, bypassing complicated local path setups.

Frequently Asked Questions
Can I link Microsoft Access to an Excel file using the OneDrive web URL?
No, Microsoft Access does not support connecting directly to a cloud-only OneDrive web URL. You must install the OneDrive desktop app and link to the local synchronized folder path.
Will updates made to the Excel file automatically sync back to Access?
Yes, if you use a linked table and the file is synced via the OneDrive desktop app, any changes made to the Excel file will reflect in Microsoft Access. Conversely, if you edit data in Access, it will update the local Excel file, which OneDrive then syncs to the cloud.
What happens to the Access linked table if my OneDrive app stops syncing?
If the OneDrive desktop app stops syncing or you lose internet connection, the linked table in Microsoft Access will continue to read from the local, cached version of the Excel file. Once the connection is restored, OneDrive will resume syncing updates to the cloud.
Why am I getting a 'file in use' error when linking the OneDrive Excel file?
This error often occurs if the Excel file is open in another program, or if another user is actively editing the file online using Excel for the Web. Ensure the file is completely closed before establishing the linked table in Access.




